Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everybody,
I get stuck with one issue.
I have the following table visual.
The "Customers" are taken from the dataset. The "Price" is calculated with a measure that is dependent on a SelectedValue Slicer.
However, only the Price of "Customer A" is changed/ adjusted there.
The Rank ist calculated with a measure that uses the value of the "Price".
I now need a DAX-command that outputs the Rank of "Customer A" so that I can display it on a card.
I've already tried and used the measure for the rank and finally applied a filter to the visual (card). However, this works because the measure calculated the "Rank" only with the "Customer A". "Customer A" is therefore always in first place.
Thank you for your help!
Kind regards
Michael
Solved! Go to Solution.
// Maybe something like this...
[Customer A Rank] =
var VisibleCustomers =
CALCULATETABLE(
DISTINCT( T[Customer] ),
ALLSELECTED( Customer )
)
RETURN
CALCULATE(
RANKX(
VisibleCustomers,
[Price],,
ASC, DENSE
),
T[Customer] = "A"
)
// Maybe something like this...
[Customer A Rank] =
var VisibleCustomers =
CALCULATETABLE(
DISTINCT( T[Customer] ),
ALLSELECTED( Customer )
)
RETURN
CALCULATE(
RANKX(
VisibleCustomers,
[Price],,
ASC, DENSE
),
T[Customer] = "A"
)
User | Count |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
81 | |
55 | |
39 | |
20 | |
12 |