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.
I currently have a list of 10 ID's .
Each ID, may run into different status.
Now if the Status is open for a particular ID, then exclude entire id of that set from the count.
For E.g., below data, 101,103 will be excluded which contains atleast one open status.
id,status
101,closed
101,open
102,closed
103,open
103,closed
count=1
How to proceed with this in Dax Direct Query, Power BI ?
Thanks in Advance.
Solved! Go to Solution.
Hi @RaghavRamky,
Based on my test, the formula below should work in DirectQuery in your scenairo.
count of id = CALCULATE ( COUNT ( Table1[id] ), FILTER ( Table1, NOT ( CONTAINS ( FILTER ( Table1, Table1[status] = "open" ), Table1[id], Table1[id] ) ) ) )
Regards
Hi @RaghavRamky,
Based on my test, the formula below should work in DirectQuery in your scenairo.
count of id = CALCULATE ( COUNT ( Table1[id] ), FILTER ( Table1, NOT ( CONTAINS ( FILTER ( Table1, Table1[status] = "open" ), Table1[id], Table1[id] ) ) ) )
Regards
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |