Forum Discussion
Rankx with Filter
Hi,
I am trying to make a rank card visual to show how the product chosen from the slicer ranks within its designated category. I want the category filter to automatically change once the product filter is changed. Would a switch function work?
This is the current measure I have:
$/S/S/W Rank =
IF
(
HASONEVALUE
('UPCData'[Product]) && NOT(ISBLANK(ALLSELECTED(UPCData[Category]))),
RANKX
(
ALL(
'UPCData'[Product]),
CALCULATE
(
[UPC Avg Weekly Dollars per Store Selling divided by Avg Weekly Items per Store Selling])),
"--"
)Thanks!
1 Reply
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
