Forum Discussion
ShrimpSurf
Helper II
4 years agoDo Not Show Zero Value
Is there a realitively simple way to eliminate zero's from tables?
- 4 years ago
Hi ShrimpSurf ,
If you want the value zero to be blank, I think you should modify the formula of the measure.
If your original formula is
Measure= SUMX(FILTER('Table','Table'[Column2]=MAX('Table'[Column2])),'Table'[Column1])It should be changed to
Measure= VAR _SUM=SUMX(FILTER('Table','Table'[Column2]=MAX('Table'[Column2])),'Table'[Column1]) RETURN IF(_SUM=0,BLANK(),_SUM)Then select Show items with no data in the Rows.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-yanjiang-msft
Community Support
4 years agoHi ShrimpSurf ,
If you want the value zero to be blank, I think you should modify the formula of the measure.
If your original formula is
Measure= SUMX(FILTER('Table','Table'[Column2]=MAX('Table'[Column2])),'Table'[Column1])
It should be changed to
Measure=
VAR _SUM=SUMX(FILTER('Table','Table'[Column2]=MAX('Table'[Column2])),'Table'[Column1])
RETURN
IF(_SUM=0,BLANK(),_SUM)
Then select Show items with no data in the Rows.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.