Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone,
Originally, I only needed to rank the sales amount BY Client in my report. So, I used this DAX formula:
AMT Rank = RANKX( ALLSELECTED('Sales'[Customer Name]), 'Sales'[1. Actual Sales Amount], , DESC )
But now, I need to view their rankings by YearMonth .
How should I modify my formula for this?
Please provide me with some advice. Thank you.
My ideal format looks like the following:
And this is a simple data model
@Lily36876 Try with:
AMT Rank =
RANKX(
FILTER(
ALLSELECTED('Sales'[Customer Name]),
'Sales'[YearMonth] = MAX('Sales'[YearMonth])
),
'Sales'[1. Actual Sales Amount],
,
DESC
)
BBF
Hello!!! Thanks for reply~
I'm try it,but my 'Sales'[YearMonth] = MAX('Sales'[YearMonth]) show error,
because 'Sales'[YearMonth] properties is column not a measure.
Hi @Lily36876
As your data model is the Sales Table filter the Date table?
Can you share sample of your data in text format or PBIX file here?
What is the expected output? in the ideal image you shares, the rak is 1 for all items
BTW, check this, it's quick similar to your case:https://community.fabric.microsoft.com/t5/Desktop/Rank-sales-value-grouped-by-month-and-year/m-p/330...
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
User | Count |
---|---|
49 | |
40 | |
18 | |
14 | |
13 |
User | Count |
---|---|
102 | |
55 | |
28 | |
18 | |
13 |