Distinct count filtered by condition using Power BI Dax

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).

Here is a measure formula that I attempted:

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

But i think i need to make changes, can you please tell how do i modify the formula?

Answer 1

Try this, it should work:

DistinctCountActiveMonths =

CALCULATE(

    DISTINCTCOUNT( 'Net Revenue Data'[Publisher Name] )

    ,'Net Revenue Data'[Active Month] = 1

)

If you want to learn more about Power BI, then read the Power BI Tutorial. Also, enroll in Power BI Certification training to become proficient in this BI tool.