Forum Discussion

Fabio74's avatar
Fabio74
Helper I
5 years ago
Solved

Issue with a measure using Power KPI Matrix

Hi everyone, I'm having troubles understanding how to create a dynamic measure that works in a Power KPI Matrix visualization. My table contains Persons (4), Fruits (3), quantity per day (0 or 1) an...
Need Help
  • MFelix's avatar
    MFelix
    5 years ago

    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.

Fabio74's avatar
Fabio74
Helper I
5 years ago

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!

MFelix's avatar
MFelix
Super User
5 years ago

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.

  • Fabio74's avatar
    Fabio74
    Helper I
    5 years ago

    Thank you very much MFelix , it works. As I have a moment I'll try and read again what you wrote to understand the "how" (which is the most difficult part for me).

    Thanks again!