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
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.