Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Power KPI Matrix Visual - Use YTD rather than most recent Week

Hi,

 

In attached pic. The KPI visual is using the most recent week 17 values (69.91% & 69.25%)

I need it to use the total values (72.37% & 69.27%).

 

See attach. On left is the KPI Visual & on the right is a regular table visual)

 

Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous ,

     

    One sample for your reference. Here we can create a measure as below to work on it.

     

    Measure 2 = 
DIVIDE (
    CALCULATE (
        SUM ( Table1[Check in ] ),
        FILTER ( ALL ( Table1 ), 'Table1'[Week] <= MAX ( Table1[Week] ) )
    ),
    CALCULATE (
        SUM ( Table1[Column] ),
        FILTER ( ALL ( Table1 ), 'Table1'[Week] <= MAX ( Table1[Week] ) )
    )
)

    Pbix as attached.

     

1 Reply

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi Anonymous ,

     

    One sample for your reference. Here we can create a measure as below to work on it.

     

    Measure 2 = 
DIVIDE (
    CALCULATE (
        SUM ( Table1[Check in ] ),
        FILTER ( ALL ( Table1 ), 'Table1'[Week] <= MAX ( Table1[Week] ) )
    ),
    CALCULATE (
        SUM ( Table1[Column] ),
        FILTER ( ALL ( Table1 ), 'Table1'[Week] <= MAX ( Table1[Week] ) )
    )
)

    Pbix as attached.