Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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, forecasted sales and the % difference between actual sales and forecasted sales (%Change).
I have created a parameter (0-100%) and what I want to do now is to filter the below table so that only the %Change (in absolute value) that are bigger than my parameter value get shown.
The filter that I have created is like this:
Type: Column --> Filter = IF(divide(Parameter[Parameter Value],100)<=abs([%Change]), TRUE,FALSE)
What am I doing wrong? Is it because my columns are dates and thus my filter is calculated differently than my measure?
Thanks!
Solved! Go to Solution.
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |