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

[Anonymous]

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

City	YEAR	LineType	OrderType	Order no
Paris	2017	HPLP	Pipes	400461062
Paris	2017	HPLP	Pipes	400578517
Paris	2017	HPLP	Pipes	400663307
Paris	2017	HPLP	Pipes	100209055
Paris	2017	HPLP	Pipes	100162131
Paris	2017	HPLP	Pipes	400604494
Paris	2017	HPLP	Pipes	400466633
Paris	2017	HPLP	Pipes	400643457
London	2017	HPLP	Pipes	400634137
London	2017	HPLP	Pipes	400455034
London	2020	HPLP	Pipes	100419496
London	2020	HPLP	Pipes	100397579
London	2020	HPLP	Pipes	100436420
London	2020	HPLP	Pipes	401864588
London	2020	HPLP	Pipes	401995256

[amitchandak · Accepted solution]

@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]

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