Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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!!
User | Count |
---|---|
70 | |
43 | |
21 | |
21 | |
13 |
User | Count |
---|---|
124 | |
42 | |
39 | |
28 | |
25 |