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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
BLUE_SKY
Regular Visitor

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

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]

BLUE_SKY_0-1713569161855.png

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.

BLUE_SKY_1-1713569406216.png

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. 

 

BLUE_SKY_2-1713569571933.png

 

I want like this. 

BLUE_SKY_3-1713569630572.png

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

1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User

Hi,

Change ALL To ALLSELECTED.

Hope this helps.

Ashish_Mathur_0-1713582588738.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

3 REPLIES 3
BLUE_SKY
Regular Visitor

Thank you for your help!!

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Ashish_Mathur
Super User
Super User

Hi,

Change ALL To ALLSELECTED.

Hope this helps.

Ashish_Mathur_0-1713582588738.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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