Forum Discussion

dreyz64's avatar
dreyz64
Helper III
6 years ago
Solved

Help - Filtering a visualization based on a parameter and a measure not working

Hi everyone,   I now have been struggling for a while with this and I am going mad as I'm sure this is something simple. I have created a table where I have various products, their actual sales, f...
Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    Hi dreyz64 ,

     

    This as to do with context I have made a single measure the actuals:

     

    Actuals_Final = SUMX(SUMMARIZE(Sheet1;Sheet1[DATE];"@ACTUALS";[ACTUALS2]);[@ACTUALS])

     

    This is additional on top of the ACTUALS2 so you need to have a intermidiate measure to calculate the values.

     

    Please check if is working correctly on the PBIX file.

     

    If it works you need to do a similar thing for forecast. and then use those measures on the Change %2

dreyz64's avatar
dreyz64
Helper III
6 years ago

Hi Felix,

Totals should be the sum of the row for each measure

MFelix's avatar
MFelix
Super User
6 years ago

Hi dreyz64 ,

 

This as to do with context I have made a single measure the actuals:

 

Actuals_Final = SUMX(SUMMARIZE(Sheet1;Sheet1[DATE];"@ACTUALS";[ACTUALS2]);[@ACTUALS])

 

This is additional on top of the ACTUALS2 so you need to have a intermidiate measure to calculate the values.

 

Please check if is working correctly on the PBIX file.

 

If it works you need to do a similar thing for forecast. and then use those measures on the Change %2