Forum Discussion

gap's avatar
gap
Icon for Helper I rankHelper I
3 years ago

Filter Matrix Rows to be visible only when all columns have values

Hello   My goal is to hide rows on a matrix when not all columns have value. So i created the below filter. What i am counting is the the total columns on each row (columns will be the Year), where...
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
3 years ago

i do not understand too.😓

gap's avatar
gap
Icon for Helper I rankHelper I
3 years ago

Found the below which heps understanding the issue. Generally adding a +0 at the measure in order not to be blank, solves the filtering issue. I just need to find a solution with no adding the +0, but at least that article helps understanding the cause.

 

Deep dive into measure filters in Power BI Desktop - SQLBI