Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

two slicers are effecting the results in the card

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 : 

VAR CatRanking = IF(HASONEVALUE('Table'[CatName]),
      RANKX ( ALL('Table'[CatName] , 'Table'[CatName]) , [Total Sales] )
)
VAR Result = IF(ISBLANK(CatRanking ) = TRUE, "N/A", CatRanking )
RETURN Result


so, this shows N/A when category and subcategory slicers are all selected.

I can select one category and I get the category rank, good (Y)
When I unselect all categories and select a subcategory It returns 1 all the time, but I don't want to show anything
because this is for category rank 

what should I do ?
1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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

amitchandak
Super User
Super User

@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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.