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

MFelix's avatar
MFelix
Super User
6 years ago

Hi dreyz64 ,

 

This is refering to the context of your measures, you probably need to use an aggregator function (SUMX) instead of a sum but this depends on the way your model is setup.

 

Can you make a mockup file with sample data and expected resutl? or share the file trough private message?

dreyz64's avatar
dreyz64
Helper III
6 years ago

HI Felix

I don't find a way to send attachements...

Any idea what I can do? Company blocks dropbox and other sharing sites.