Forum Discussion
Issue with a measure using Power KPI Matrix
Dear MFelix , thank you for your reply. I've modified the measure as you've explained and it works, but when I use the Months filter/slicer ... it doesn't seem to work anymore:
As for the other question, I'd like to replicate this visualization made in an Excel file. As you can see, the Trend is shown for each category and subcategory
whereas in my PowerBi visualization, the trend is shown only for the subcategory. When I click on the "arrow" to collapse the category, no trend is shown (but maybe the visualization doesn't support this feature).
Hope is clearer now. Thanks!
Hi Fabio74 ,
I just did the change of the month calculations instead of having hard coded 5 it counts the number of months so when you select 1 the values is the same has the total.
Do you want to calculate the average for the selected months and fruits for that person?
Regarding the second part try the following custom visual:
https://appsource.microsoft.com/en/product/power-bi-visuals/wa200002816?tab=overview
Do you want to calculate the average for the selected months and fruits for that person?
Yes please, sorry if it wasn't clear 🙂
As for the visual, I've also taken a quick look at the Multiple Sparklines one, but it seemed to me that it worked only at the category level. But maybe I was wrong. I'll take a second look. Thanks!
Hi Fabio74 ,
The measure you have written gives you the incorrect value you need to redo it to:
Mo Avg Qty = DIVIDE ( CALCULATE ( SUM ( 'Data Table'[Qty] ), ALLSELECTED(Dates) ), CALCULATE ( DISTINCTCOUNT ( Dates[EndOfMonth] ), ALLSELECTED ( Dates ) ) )Check result attach.