Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have made below measure which when used in a table should (in my world) show only filtered results.
MEASURE:
However, the table shows the entire dataset, regardless of the format, itemaction and status (the three filters).
Why is this happening? Why do not only results that fulfil the filter criteria display in the table?
Solved! Go to Solution.
hi @Anonymous
Just adjust the formula by FILTER as below:
Number of succeeded executions =
CALCULATE (
COUNT ( ExecutionLog3[ExecutionId] );
FILTER (
ExecutionLog3;
ExecutionLog3[Format] IN { "RPL"; "PBIX" }
&& ExecutionLog3[ItemAction] IN { "Render"; "ConceptualSchema" }
&& ExecutionLog3[Status] = "rsSuccess"
)
)
Regards,
Lin
hi @Anonymous
Just adjust the formula by FILTER as below:
Number of succeeded executions =
CALCULATE (
COUNT ( ExecutionLog3[ExecutionId] );
FILTER (
ExecutionLog3;
ExecutionLog3[Format] IN { "RPL"; "PBIX" }
&& ExecutionLog3[ItemAction] IN { "Render"; "ConceptualSchema" }
&& ExecutionLog3[Status] = "rsSuccess"
)
)
Regards,
Lin
I appreciate your feedback guys, although my question still remains unanswered.
Why does the measure filter my table and display only rows with "RPL" for instance, but when I add another condition, "PBIX", the table displays all types of formats. Not just PBIX and RPL.
Nevermind guys, when I use the dax supplied by you the table filters as expected.
How come my dax does not filter my table, but yours does?
This is not how measure filters work.
The measure is evaluated for each row in your table visual.
If you want to filter the visual, use the Filter pane or slicers.
Thanks for the reply!
What confuses me however is when I only have one condition, like "RPL", the measure does filter the table to only display RPL rows. But when I have two conditions the entire dataset is still displayed in the table.
Below works, but not measure in the first post.
Hi @Anonymous
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
100 | |
83 | |
76 | |
65 |
User | Count |
---|---|
120 | |
111 | |
94 | |
83 | |
77 |