ObeeOne's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Anon

Country

Latest Posts

Re: Publication - Use Parameters to determine a selected date range
The technique to getting this to work requires a small hack. The Pyramid team knows about the work-around, and have been looking into better functional support for this scenario.…
- Redeemed from the Dark Side (Power BI)
- Obee1
- 1 yr ago
- 2
- Questions & Answers
- Answer
- Reported - view
Re: Show an average of the selected members of a filter.
This is not currently possible - because the underlying query does not allow for 2 levels of granularity in the same response. I believe there is a feature request on the forum for this already.
- Redeemed from the Dark Side (Power BI)
- Obee1
- 1 yr ago
- Questions & Answers
- Reported - view
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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Questions & Answers
- Reported - view

1 2

Back to top

Home

View all topics