Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
"Rate %" is a dax measure=DIVIDE(a,b,c)
I want to be able to filter to show only the result that is greater than or equal to 5%
I could simply achieve this by using "Visual Level Filter" as shown bellow;
And the above works.
But I am wondering if there's a way I can achieve thesame using only measure. As I am wanting to make it dynamic.
For Example:
If Rate % was a Table Column and not a Measure, I would have written the dax like the following;
Measure = Calculate(DIVIDE(a,b,c), Filter(table, Column >= 0.05)
The question is how do I achieve thesame when it's a dax and not a table column?
Measure = Calculate(DIVIDE(a,b,c), Filter(Rate % >= 0.05) - This does not work lol.
Please help, thanks in advance.
Solved! Go to Solution.
@AnonymousOh wow, It worked.
I did not think it would work, because I had tired doing
Measure = Calculate(Rate %, If([Rate %]>0.05,[Rate %], Blank()))
And I got an error message, Calcuate used in True/False expression..This is not allowed.
😂🤣
Your Solution tha uses only the If statement Worked!
Thank You!!