topic Re: How to apply visual level filter(uning dax measure) to dax meaure result. in DAX Commands and Tips

How to apply visual level filter(uning dax measure) to dax meaure result.

Eli_ — Tue, 04 Feb 2020 15:26:26 GMT

"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.

Re: How to apply visual level filter(uning dax measure) to dax meaure result.

Anonymous — Tue, 04 Feb 2020 17:27:39 GMT

I am not sure but try this one

If([rate%]>0.05,[rate%],blank())

Thanks,
Pravin

Re: How to apply visual level filter(uning dax measure) to dax meaure result.

Eli_ — Tue, 04 Feb 2020 17:41:35 GMT

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!!