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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
Anonymous
Not applicable

Urgent help - Distinct count of a column in a GroupBy table

Hi All,

I am creating a calculated table where the data is as below. I need to calculate the distinct count of the Order column and perform ranking over it. I have the ranking figured out, but unable to create a table with GroupBy function to calculate the distinct count of the OrderNumber. Is there an alternative approach? Any help is highly appreciated.

Order Count = GROUPBY(Datasource,Datasource[City],Datasource[YEAR],Datasource[OrderType],Datasource[Order no], "Count",Distinct(CURRENTGROUP(), Datasource[Order no])))

 

CityYEARLineTypeOrderTypeOrder no 
Paris2017HPLPPipes400461062
Paris2017HPLPPipes400578517
Paris2017HPLPPipes400663307
Paris2017HPLPPipes100209055
Paris2017HPLPPipes100162131
Paris2017HPLPPipes400604494
Paris2017HPLPPipes400466633
Paris2017HPLPPipes400643457
London2017HPLPPipes400634137
London2017HPLPPipes400455034
London2020HPLPPipes100419496
London2020HPLPPipes100397579
London2020HPLPPipes100436420
London2020HPLPPipes401864588
London2020HPLPPipes401995256
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous ,

You can try like

new measure

rankx(allselected(Datasource) , calculate(distinctcount(Datasource[Order no])))

 

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous ,

You can try like

new measure

rankx(allselected(Datasource) , calculate(distinctcount(Datasource[Order no])))

 

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

Thanks @amitchandak , I tried the GroupBy and the measure you sent, calculation works as expected. Thanks for your swift response.

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors
Top Kudoed Authors