Forum Discussion

Dom87326's avatar
Dom87326
Helper II
4 years ago
Solved

KPI Visualization does not sum the data YoY

Hello,     I'm trying to compare different time periods with Power BI KPI visuals and for that reason created following measures:      Purchases = SUM('Purchases'[Quantity]) Previous Purchases...
Need Help
  • aj1973's avatar
    aj1973
    4 years ago

    Hi Dom87326 

    Your Measure must be 

     

    Previous Purchases = CALCULATE ([Purchases] , SAMEPERIODLASTYEAR('Date'[Date])

     

  • aj1973's avatar
    aj1973
    4 years ago

    Dom87326 

    The filters are applied on the viusal level not the the whole page

    Try to CRTL / SELECT the 3 band chart and watch the card please

aj1973's avatar
aj1973
Community Champion
4 years ago

Change the measure using SELECTEDVALUE[YEAR MONTH] as a VAR and CALCULATE the sum of Purchases filtering the selected value .

Dom87326's avatar
Dom87326
Helper II
4 years ago

Hi again aj1973 ,


Well, I've changed the initial measure to:

Purchases = 
VAR _YM = SELECTEDVALUE('Date'[Year Month])
VAR _CALC = CALCULATE (SUM('Purchases'[Quantity])), 'Date'[Year Month])
RETURN 
_CALC

However KPI still wouldn't return 2022 results.. Maybe I'm doing something wrong here? 

Thanks!

  • aj1973's avatar
    aj1973
    Community Champion
    4 years ago

    Dom87326 

    The filters are applied on the viusal level not the the whole page

    Try to CRTL / SELECT the 3 band chart and watch the card please