Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
Hope you can help me.
I have a table and I would like to rank each row grouped by country and with 2 conditions. The conditions are as follows:
Different dates may reflect different ranking.
The final result should be like this:
Can you please help me?
Thanks in advance.
Solved! Go to Solution.
Hi,
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.
It is for creating a measure.
Rank measure: =
IF (
HASONEVALUE ( Country[Country] ),
CALCULATE (
COUNTROWS ( Data ),
WINDOW (
1,
ABS,
0,
REL,
SUMMARIZE (
ALL ( Data ),
Country[Country],
'Product'[Product],
Data[Qty],
Data[Sales Amount]
),
ORDERBY ( Data[Qty], DESC, Data[Sales Amount], DESC ),
KEEP,
PARTITIONBY ( Country[Country] )
)
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.
It is for creating a measure.
Rank measure: =
IF (
HASONEVALUE ( Country[Country] ),
CALCULATE (
COUNTROWS ( Data ),
WINDOW (
1,
ABS,
0,
REL,
SUMMARIZE (
ALL ( Data ),
Country[Country],
'Product'[Product],
Data[Qty],
Data[Sales Amount]
),
ORDERBY ( Data[Qty], DESC, Data[Sales Amount], DESC ),
KEEP,
PARTITIONBY ( Country[Country] )
)
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hello @Jihwan_Kim ,
Measure is not working when I select my table.
I only have a single table, should it worl the same way?
Rank measure: =
IF (
HASONEVALUE ( 'Data'[Country] ),
CALCULATE (
COUNTROWS ( 'Data' ),
WINDOW (
1,
ABS,
0,
REL,
SUMMARIZE (
ALL ( 'Data' ),
'Data'[Country],
'Data'[Product],
'Data'[Qty],
'Data'[Sales Amount]
),
ORDERBY ( Data[Qty], DESC, Data[Sales Amount], DESC ),
KEEP,
PARTITIONBY ( 'Data'[Country] )
)
)
)
Thank you!
User | Count |
---|---|
58 | |
21 | |
18 | |
16 | |
12 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |