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,
We can filter multi column using visual level filter in Matrix in power bi.
I tried to filter multiple column by using IF functionin DAX and Edit Query. But getting different value.
comp vol2 = IF('Table1'[comp status]="pass",1,IF('Table1'[comp status]="fail",1,IF('Table1'[Work Cat]="uw",1,0)))
Please find attached .pbix file and let me know is possible to filter multiple column using IF function or any other function or formula.
https://drive.google.com/file/d/1YsorLAFOHqKZ_aexsP23axkchoucQ_bz/view?usp=sharing
Regards,
Salem
Solved! Go to Solution.
I hope you realise the reason why you are getting 28 in the first visual, is because you did not put the filter condition of comp status = "pass" AND "fail". Do you want this condition ? If no, simply delete it from the formula.
I think you are trying to count all compvol entries in the table which have comp status as "pass" or "fail" and work cat as "uw". You can try the below.
CompVol2Measure =
CALCULATE (
COUNTROWS ( Table1 ),
FILTER (
Table1,
Table1[comp status] IN { "pass", "fail" }
&& Table1[Work Cat] = "uw"
)
)
Hi Nikhil,
Thanks for your reply.
I have created the measure and found half of expected matrix.
Please have a look is it possible to make the value 28 instead of 14.
Regards,
Salem
I hope you realise the reason why you are getting 28 in the first visual, is because you did not put the filter condition of comp status = "pass" AND "fail". Do you want this condition ? If no, simply delete it from the formula.
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |