Power Bi - DAX Help needed - How to count month with zero sales at a aggregated level ?

[Mosoky]

Hi All,

I am facing issues in deriving the expected month count as shown in Diagram A. The " - " is due to sales and return within the same month as illustrated in Diagram B

This is current dax that I have tried.

Mth Sales Count =

 CALCULATE(

    DISTINCTCOUNT('Calendar'[month]),

    FILTER('Sales data',[Revenue]>0))

 Diagram A (Above) / Diagram B (Bottom)

Appreciate any advice given! Thanks in advance!

[MFelix]

Hi @Mosoky ,

Your calculation is counting the months within the dataset that have value above 0 so if we look at you data in fact you have 2 dates for Fruit that is October (Apple and Durian) and November (Orange), so the result is correct.

What is the result you need to have is it based on month or Category?