Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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 |
Solved! Go to 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 ,
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
Thanks @amitchandak , I tried the GroupBy and the measure you sent, calculation works as expected. Thanks for your swift response.