DAX MODIFICATION

[BIswajit_Das]

There are three measures to set color for a column in a table visual
i.e

1) SUB1_EP_COLOR =
VAR _sub1 = SELECTEDVALUE('Z_EP_DATA'[#WINNING%GAP_WITH_BO_PARTY_SUB1_EP])
RETURN
IF(LEFT(_sub1,1) = "B","#fcdc9c",IF(LEFT(_sub1,1) = "I","#9df2d1",IF(LEFT(_sub1,1) = "J","#95bcf5",IF(LEFT(_sub1,1) = "O","#fabee0"))))

2) SUB2_EP_COLOR =
VAR _sub1 = SELECTEDVALUE('Z_EP_DATA'[#WINNING%GAP_WITH_BO_PARTY_SUB2_EP])
RETURN
IF(LEFT(_sub1,1) = "B","#fcdc9c",IF(LEFT(_sub1,1) = "I","#9df2d1",IF(LEFT(_sub1,1) = "J","#95bcf5",IF(LEFT(_sub1,1) = "O","#fabee0"))))

3) SUB1_EP_COLOR =
VAR _sub1 = SELECTEDVALUE('Z_EP_DATA'[#WINNING%GAP_WITH_BO_PARTY_SUB1_EP])
RETURN
IF(LEFT(_sub1,1) = "B","#fcdc9c",IF(LEFT(_sub1,1) = "I","#9df2d1",IF(LEFT(_sub1,1) = "J","#95bcf5",IF(LEFT(_sub1,1) = "O","#fabee0"))))
Needed measure is a single measure
which can work on multiple selected values for multiple measures
Thanks

[ValtteriN]

Hi,

It is a bit unclear what your goal is but for now I will assume the following:

1. You have multiple slicers that you want to determine your color
2. The measure should work with multiple measures

Dax:

Color combination switch =

var _color1 = MAX('Color1'[Color1])

var _color2 = MAX('Color2'[Color2])

var _color3 =MAX('Color3'[Color3])

return

SWITCH(_color1&_color2&_color3,

"AAA","#fcdc9c",

"AAB","#9df2d1",

"AAC","#95bcf5",

"ABA","#fcdc9c",

"ACA","#9df2d1",

"ABB","#95bcf5") //Continue the logic

This measure will return a color based on the state of the 3 slicers.

E.g. 

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/