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

The table should give similar results as the one on top of the report?

  • dreyz64's avatar
    dreyz64
    Helper III
    6 years ago

    The Table on the top is with all information. All % Changes regardless of the threshold.

    I would like to achieve the table at the bottom where i only see values where % changes is bigger than the threshold in absolute.

    I wanted to do this with a filter but could not manage. So now I am summing up each measure if they are respecting the condition abs(% Change) > Threshold.
    However the totals are all wrong.