Drill Down - Hide rows

[avi081265]

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 

[v-xinruzhu-msft]

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.

[avi081265]

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

[v-xinruzhu-msft · Accepted 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.

[avi081265]

Can someone please guide on above isue or suggest any other alternate way to display same  as mentioned above.