Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
sqldev2017
Employee
Employee

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 / 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,

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

View solution in original post

3 REPLIES 3
PattemManohar
Community Champion
Community Champion

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





Did I answer your question? Mark my post as a solution!

Proud to be a PBI Community Champion




LivioLanzo
Solution Sage
Solution Sage

Hi @sqldev2017

 

are you able to post a sample of your data?

 

thx

 


 


Did I answer your question correctly? Mark my answer as a solution!


Proud to be a Datanaut!  

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.