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.
Hello all
I have the following data in a table visual and would like to create a measure I can use to filter the table so that only Site 4 is displayed i.e. records where there is a Method value for both A and B, but not A only, and not any other combination of Method values. Is this possible?
Thank you.
Site | Method |
1 | A |
2 | A |
2 | C |
3 | A |
4 | A |
4 | B |
5 | A |
5 | B |
5 | C |
try to use a measure to filter by TRUE like
Measure =
IF(
CALCULATE(DISTINCTCOUNT(Table[Method]), ALLEXCEPT(Table, Table[Site]), Table[Method] IN {"A", "B"}) = 2,
TRUE(),
FALSE()
)
Thank you @az38, that formula works nicely. But how do I filter on TRUE? I was hoping to be able to filter my table to show only the true values, but when I move the measure to the visual level filter it's not possible to select anything.
You also can create a calculated column with the same formula and place it to filter. It should work
That works nicely, thank you @az38
Finally, how would I add another condition to that formula? I would like to apply this to the dataset where only the the years = 2017, 2018 and 2019. There is a related table with a [YEAR] column.
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 |
---|---|
89 | |
86 | |
75 | |
69 | |
68 |
User | Count |
---|---|
220 | |
128 | |
117 | |
82 | |
77 |