How to remove Zeros in a measure

[h1629]

I have crated measure which is working good , but I am unable to filter the row where the measure value is zero. Through filter panel it should not be filtered. I need a DAX query to hide the last row with ID =C where measure value is 0.

Measure =

SWITCH(TRUE(),

SELECTEDVALUE('Table'[ID])="C",0,

SELECTEDVALUE('Table'[ID])=BLANK(), CALCULATE(SUMX('Table','Table'[Value]),'Table'[ID2]=BLANK(),ALLEXCEPT('Table','Table'[ID2])),

SUMX('Table','Table'[Value]))

[talespin · Accepted solution]

hi @h1629 

Use this for Sum value

IF( SELECTEDVALUE('Table'[ID]) = "C", BLANK(), SUM('Table'[Value]) )

Use this for other measure

Measure =

SWITCH(TRUE(),

SELECTEDVALUE('Table'[ID])="C",BLANK(),

SELECTEDVALUE('Table'[ID])=BLANK(), CALCULATE(SUMX('Table','Table'[Value]), ISBLANK('Table'[ID]),ALLEXCEPT('Table','Table'[ID])),

SUMX('Table','Table'[Value]))

[h1629]

It is a Data model , so we can canot create any flag and put it in the Filter panel to filter the rows.