Segmenting Data based on 2 measures

hi guys, I have 2 measures Customer Sales Rank & Margin Rank. Using the RANKX function, I attach a customer a rank for each of these measures. They work great, the problem I have is now I want to se...

DAX

stevedep
5 years ago
Hi,

It's possible when you create a helper table with the value of the classes. You would then also create the measure below and filter your scatterplot on this measure by filtering our blanks.

___ClassCheck = if(SELECTEDVALUE(Classes[Class]) = "Bad", COUNTROWS(FILTER(VALUES(Sales[Cust]),[___RankCustomer] <= 3)), COUNTROWS(FILTER(VALUES(Sales[Cust]),[___RankCustomer] > 3)))

This works in my example, as seen here:

In this video, you see how I create the visual from scratch.
Link to the file here.

Pls mark as a solution if so. Thumbs up for the effort are appreciated.

Kind regards,

Steve.

stevedep

Memorable Member

5 years ago

Hi,

It's possible when you create a helper table with the value of the classes. You would then also create the measure below and filter your scatterplot on this measure by filtering our blanks.

___ClassCheck = if(SELECTEDVALUE(Classes[Class]) = "Bad", COUNTROWS(FILTER(VALUES(Sales[Cust]),[___RankCustomer] <= 3)), COUNTROWS(FILTER(VALUES(Sales[Cust]),[___RankCustomer] > 3)))

This works in my example, as seen here:

In this video, you see how I create the visual from scratch.

Link to the file here.

Pls mark as a solution if so. Thumbs up for the effort are appreciated.

Kind regards,

Steve.

stevedep

Memorable Member

5 years ago

cdawidow pls let us know if this works for you.

Kind regards, Steve

Forum Discussion

Segmenting Data based on 2 measures