ObeeOne's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Anon

Country

Latest Posts

Re: Show an average of the selected members of a filter.
@Jair Rangel please provide some examples of what you're trying to do - maybe via some images.
- Redeemed from the Dark Side (Power BI)
- Obee1
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Previous Month Value
@Paul Narup It works fine for me. I would suggest you make all the calcs sharable. I think there is added complexity when using some or all as one-off items in a report.
- Redeemed from the Dark Side (Power BI)
- Obee1
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Previous Month Value
Create a formula in 'Formulate', using a single 'data point'. The Data point should be your measure, then select the date attribute/hierarchy. Instead of picking a specific element in the date,…
- Redeemed from the Dark Side (Power BI)
- Obee1
- 2 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: How to calculate an average at a lower Time level of detail than a Discovery
It sounds like you need to add (or change) the stock cover measure in the semantic model to an aggregate type of "average". As your queries are built, it will then average all the values for that…
- Redeemed from the Dark Side (Power BI)
- Obee1
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Question on distinct count for each value
Have you tried using distinct count measures and bidirectional joins in the model design?
- Redeemed from the Dark Side (Power BI)
- Obee1
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Difference actual week- week prev year
What is KW - a measure or an attribute? Also clarify what you mean by '6 week filter'. Are you Including this inside the KPI somehow or are you using the filter in your report that contains the KPI?
- Redeemed from the Dark Side (Power BI)
- Obee1
- 2 yrs ago
- Questions & Answers
- Reported - view

1 2 3

Back to top

Home

View all topics