How to make no data rows invisible?

[Anonymous]

In a report, I wish I can hide those rows without data in them.

For example,

Toronto   Server_A    num_1 num_2  num_3

If num_1,num_2 and num_3 are zeros, then this row will be hidden.

How to make it?

[Ritaf1983 · Accepted solution]

Hi @Anonymous 
You can create flag measure like:
flag = if([num1]=0 &&([num2]=0&&([num3]=0,0,1)

and then use this measure as a visual filter 
flag = 1

please see the solution of @v-rzhou-msft in the linked discussion including the sample file:
https://community.fabric.microsoft.com/t5/Desktop/Hide-Rows-in-Table-Matrix/m-p/3255654

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly