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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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

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

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.