Forum Discussion

AvPowerBI's avatar
AvPowerBI
Post Patron
5 years ago

Matrix Visualization - Suppress Zero and Missing Rows

Hi,   I am currently using a Matrix Visualization, I want Suppress Zero and Missing Rows? Currently all the Rows are showing because of the way the DAX Measure is being calculated and cannot think...
amitchandak's avatar
amitchandak
Super User
5 years ago

AvPowerBI , not very clear. Try measure like

 

if([measure] =0 , blank(), [measure])

 

if(calculate([measure]) ,allexcept(Table,Table[row])) =0, blank(), [measure]) // row is column on row.