Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
48 | |
44 | |
19 | |
14 | |
14 |
User | Count |
---|---|
107 | |
57 | |
29 | |
20 | |
16 |