Power BI DAX Distinct Count Filtered by Condition

Question

I have a data set with publishers with revenue by month. Publishers are considered to be "active" month if their revenue is equal or greater than 1000 for a given month.

Now, I want to count the distinct number of "active" publishers over a monthly trend using Power BI (DAX).

Please advise how to write this formula to achieve the desired result.

Answer 1

You can go with this:

DistinctCountActiveMonths =
CALCULATE(
    DISTINCTCOUNT( 'Net Revenue Data'[Publisher Name] )
    ,'Net Revenue Data'[Active Month] = 1
)

If you wish to master Power BI Concepts, Check out Power BI Training content topics now!