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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
BLUE_SKY
Frequent 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
Frequent 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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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