Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Suppose you have category and subcategory slicers, you can select all and multi-select
and we have a ranking measure that let's say using the measure (total sales) giving me the rank of category.
I have measure for category rank :
Solved! Go to Solution.
Thank you but I assume you replied the same response for each of my 2 different questions.
I found the solution for this problem, it was easy I just didn't think about it...
when you use interactions like when you select category slicer don't affect it subcategory and vice-versa
it works now.
thanks
Thank you but I assume you replied the same response for each of my 2 different questions.
I found the solution for this problem, it was easy I just didn't think about it...
when you use interactions like when you select category slicer don't affect it subcategory and vice-versa
it works now.
thanks
@Anonymous , if you create a rank on a category and add a subcategory column in the visual. Then rank will happen for category inside sub-category
Your options are
RANKX (
ALL('Table'[CategoryName], 'Table'[SubCategoryName] ),
[total sales] , , DESC
)
or
RANKX (
filter(ALL('Table'[CategoryName], 'Table'[SubCategoryName] ),'Table'[CategoryName] = max('Table'[CategoryName]) ),
[total sales] , , DESC
)
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
User | Count |
---|---|
17 | |
14 | |
13 | |
13 | |
12 |
User | Count |
---|---|
19 | |
14 | |
14 | |
10 | |
9 |