How to remove columns with only 0s as values in a matrix

[Anonymous]

I am having a matrix visualization like this

I want to remove the countries with 0 total sales (columns with full 0s) from the matrix. The matrix is dynamic so opting out some countries is not possible. The pack size and country names are columns from different tables and the values is a measure given below

Overall_Sales = 
var a  = HASONEFILTER('Date Master'[Day_final])
return
IF(a,CALCULATE([Sales],DATESMTD('Date Master'[Date])),[Sales])

Is there any way to eliminate the columns total (or countries) with 0 sales?

[Ahmedx · Accepted solution]

pls try this

Overall_Sales =
var a = HASONEFILTER('Date Master'[Day_final])
VAR b = [Sales]>0
return
IF(a&&b,
CALCULATE([Sales],DATESMTD('Date Master'[Date])),IF(b,[Sales]))

[Anonymous · Accepted solution]

Hi @Anonymous 

You can create a new measure.

Measure =
IF ( [Overall_Sales] > 0, [Overall_Sales] )

Then put the measure to the matrix.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ahmedx · Accepted solution]

pls try this

Overall_Sales =
var a = HASONEFILTER('Date Master'[Day_final])
VAR b = [Sales]>0
return
IF(a&&b,
CALCULATE([Sales],DATESMTD('Date Master'[Date])),IF(b,[Sales]))

[Vallirajap]

Hi @Anonymous 

Choose the table and go to filter pane -> Expand the total sales filter card.

Select 'is greater than' and enter 0 in the text box, then click Apply Filter as in the below image.

Did I answer your question?

Mark my post as a solution, this will help others...!

Hit the kudo also,

Thank you

[Anonymous]

Hi @Vallirajap 
Thanks for your response. I have tried this filter. It would remove the pack size with 0 sales. I need to remove the cities (columns) with 0 sales.