Get Count based on condition or filter

[sqldev2017]

I have a calculared measure - say  "Revenue".

I have a dimension called Accounts, which contains Unique AccountID.

The "Revenue" measure relates to the Accounts - Revenue for an account / Quarter/ Region.

I want to create a new Column using DAX ,  which returns DISTINCT Count of all Accounts  where "Revenue" > 500000 

Bear in mind that , this "Revenue" , is a calculated Measure.

Thank You,

[PattemManohar]

@sqldev2017 Please post the sample data in copiable format, which will be helpful to suggest any accurate solution.

[LivioLanzo]

Hi @sqldev2017

are you able to post a sample of your data?

thx

[sqldev2017 · Accepted solution]

 Thank you for your replies.

I think I found the solution in a different POWERBI thread - 

CALCULATE(DISTINCTCOUNT(Sales[Sales_ID]),FILTER(VALUES(Sales[Sales_ID]),[YTDSales]>3000))