How to handle calculate then filter scenario?

[FreemanZ]

With DAX, it is always easy to filter then calculate.  What if we have to calculate then filter?

 

Supposing we have a table with three columns: ReportMonth, Product, and SalesAmount. The requirement is to get the list of the Products with 0 SalesAmount in all ReportMonths.  How could it be done?

 

It would be super easy to have a intermediate physical calculated table. But how to do that without buiding a physical intermediate table?

I thought it would be easy to use SUMMARIZE + ADDCOLUMNS, but i don't know how to code for the added column.

Could you help?

[tamerj1 · Accepted solution]

Hi @FreemanZ 

let's suppose you have a table visual sliced by ReportMonth and Product and you placed the Sales Amount measure along with them. Then you can go the filter pane of the table visual, select the Sales Amount measure, select "is" and type "0" then apply the filter