topic Re: How to remove Zeros in a measure in DAX Commands and Tips

How to remove Zeros in a measure

h1629 — Wed, 06 Mar 2024 06:31:16 GMT

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]))

Re: How to remove Zeros in a measure

h1629 — Wed, 06 Mar 2024 06:42:20 GMT

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

Re: How to remove Zeros in a measure

talespin — Wed, 06 Mar 2024 06:43:42 GMT

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]))