cancel
Showing results for 
Search instead for 
Did you mean: 
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
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
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors