DAX - Show value 1 if value in a month - If no zero

[nankerp]

In my datamodel I want to show the value 1 if there is any turnover that certain month. If not zero.

I thougth it was easy by just using IF([turnover]>0;1;0) but the products are not grouped. I need the product only mentioned one time for right subgroup.

[v-jiascu-msft]

Hi @nankerp,

Could you please post a sample and the result you want? 

Best Regards!

Dale

[nankerp · Accepted solution]

I think I found a solution. 

What I did was first making a measure: 

COTGTZero=sumx(factTurnover;if(factTurnover[Sales]>0;1;0)).

Then I made a new Measure: 

ShowOneIfSalesThatMonth=COTGTZero/COTGTZero.

It works when I show it in my report.