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...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

HI AvPowerBI 

Can you please provide more info with screenshots, input and required output in table format for the community so that you ask can be better understood and resolved quickly.

from what I understand, I would use

Visual Control = 
var _result = 
CALCULATE(
    SUM('Table'[Value]),
    ALLEXCEPT('Table','Table'[Category])
)
return
IF(
    _result>0,
    1,0
)

Then,