Forum Discussion

sqldev2017's avatar
sqldev2017
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago
Solved

Get Count based on condition or filter

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 / Qua...
Need Help
  • sqldev2017's avatar
    sqldev2017
    7 years ago

     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))
LivioLanzo's avatar
LivioLanzo
Icon for Solution Sage rankSolution Sage
7 years ago

Hi sqldev2017

 

are you able to post a sample of your data?

 

thx

  • sqldev2017's avatar
    sqldev2017
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

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