How to Make Rankx DAX with multi-Row and Slicer in Matrix without +-option and step.

[BLUE_SKY]

Hello, 

I want to make "Rankx DAX" with multi-Row and Slicer in Matrix without +-option and stepped layout.

So, I make Dax Like This. 

================================================

C_Likeability = AVERAGEX('LIKEABILITY',LIKEABILITY[LIKEABILITY])

C_RANK_LIKE =

RANKX(

    ALL('LIKEABILITY'[PRODUCT],LIKEABILITY[COLOR],LIKEABILITY[SIZE]),

    LIKEABILITY[C_Likeability]

)

===================================================
[Power BI]

I make visualization like this. 

I don't use +/- icon and  stepped layout because this format is more simple.

When I checked Coutry Slicer and AGE Slicer, C_RANK_LIKE has Changed dynamically.

I satisfied with this operation for Country and AGE Slicer.

These features (country and age) don't include in this matrix.

--------------------------------------------------------------------

Next, i click color slicer. Color include in this matrix. 

Result is this. 

I want like this. 

C_RANK_LIKE has changed dynamically.

==========================================

How to solve this issue. Please Help.

https://drive.google.com/file/d/1nWCfwX-5sXmbBYLhflUn5p_Pc0CJ6O9N/view?usp=drive_link

[BLUE_SKY]

Thank you for your help!!

[Ashish_Mathur]

You are welcome.

[Ashish_Mathur · Accepted solution]

Hi,

Change ALL To ALLSELECTED.

Hope this helps.