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.
Hi, honestly Im coming here as a desperate DAX noob and I hope somebody can help me 🙂
I have a live connection (so Im not able to edit/add columns) in my report with many pages. I got a request to exclude a specific type of products from one group, from the entire report. Let's say, I have group of products X, Y, Z, next I have a layer for each group with the types of products A B C. What I want to achieve is to exclude type A from group X only.
I know that I cannot apply filters with an IF statement also I can't apply measure as a filter as long as it's not a calculated measure (but that would require writing new measures for each value I have in charts). Please correct me if I'm wrong.
What could be the best efficient way to apply that exclusion? I don't want to apply it on each chart separately and write measures for each value. Many thanks in advance!
Solved! Go to Solution.
Hi,
You can use filter measure combined with a calculation group to achieve this. E.g.
Table:
calculation group:
calculate(selectedmeasure(),FILTER('Table (9)',[Filter Measure for Q2 and Q3] = 1))
This approach will filter the target table based on the if logic. So in this case My visual will only show Q2 and Q3 values:
Edit, here is a link to an article by SQLBI about calculation groups:
Introducing Calculation Groups - SQLBI
Proud to be a Super User!
Hi,
You can use filter measure combined with a calculation group to achieve this. E.g.
Table:
calculation group:
calculate(selectedmeasure(),FILTER('Table (9)',[Filter Measure for Q2 and Q3] = 1))
This approach will filter the target table based on the if logic. So in this case My visual will only show Q2 and Q3 values:
Edit, here is a link to an article by SQLBI about calculation groups:
Introducing Calculation Groups - SQLBI
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
70 | |
36 | |
21 | |
18 | |
15 |
User | Count |
---|---|
126 | |
30 | |
28 | |
24 | |
22 |