The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
"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 |
---|---|
15 | |
12 | |
8 | |
7 | |
7 |
User | Count |
---|---|
24 | |
20 | |
12 | |
10 | |
7 |