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!