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.