Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
92 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |