Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
I have following Drill Down , in this drill drown, I want to show only row where is zero (0) count is there. I dont want do to display any row where count is > 0.. IN followin mateix table, Manual, Drawing, Electrical, Risk, Certification, Declaration and Schema are different measures. As I mention above, I just want to display RED color cell or 0 count value rows
Is this possible, if yes how can do it. I try to use filter on matrix table, but once I set filter as > 0 for any maeasure, it will hide everything.
How can I
Solved! Go to Solution.
Hi @avi081265
If you want to keep the rows with 0 in each measure, you can use the following method
Sample data
Measure = IF(COUNTROWS(test)>=2,1)
Measure 2 = IF(SUM(test[Column1])>50,1)
Then create a measure to judge them
Measure 4 = IF(OR([Measure],[Measure 2]),1)
Then put it to the visual filter
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @avi081265
You can create a measure and determine whether the measures in the matrix are equal to 0, if not equal to 0, return 0, otherwise return 1, and then put the measure into the visual filter, set the measure value to 1 to display.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Yolo, above measure already created with same formulas, like below
Manual = IF(calculate (count(Merge1[Id]),Merge1[Items.Level-2]="Manual")=0,1,0)
Same measure I added in Matrix like below, that is why it is showing 0 or 1 with the conditional formatting for red color for 0 and green for 1. My ask only to show green color measures. If you pur filter for those measure wher count is 1, it will filter each measure and no measure will be display in Matrix
Hi @avi081265
If you want to keep the rows with 0 in each measure, you can use the following method
Sample data
Measure = IF(COUNTROWS(test)>=2,1)
Measure 2 = IF(SUM(test[Column1])>50,1)
Then create a measure to judge them
Measure 4 = IF(OR([Measure],[Measure 2]),1)
Then put it to the visual filter
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Can someone please guide on above isue or suggest any other alternate way to display same as mentioned above.
User | Count |
---|---|
101 | |
90 | |
78 | |
70 | |
69 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |