How do you add OR function to a IF/MAX measure?

[dli9]

My chart displays several colors and I'd like to list them in the measure, but I keep receiving an error message that says the syntax is not correct. I do not want to create one measure per color either. 

Scaled Volume MeasureIFMAX = IF(MAX((ColorsTable[ColorsTable])="Red", (Colorstable[ColorsTable])="Yellow"), [Raw Volume Total] * [Power BI Scale],[Raw Volume Total]))

Colors should include, Red, Yellow, Blue, and Orange

[Ashish_Mathur]

Hi,

Does this measure work?

=if(MAX(ColorsTable[ColorsTable])="Red"||MAX(ColorsTable[ColorsTable])="Yellow"||MAX(ColorsTable[ColorsTable])="Blue"||MAX(ColorsTable[ColorsTable])="Orange",[Raw Volume Total] * [Power BI Scale],[Raw Volume Total])

[Fowmy]

@dli9 

Could be this : 

Scaled Volume Measure = 
IF(
    MAX( ColorsTable[ColorsTable]) IN {"Red","Yellow", "Blue","Orange"}, 
    [Raw Volume Total] * [Power BI Scale],
    [Raw Volume Total]
)

[dli9]

@Fowmy 

That worked! However, I'm running into the issue of all my colors being scaled now when I filter by All Colors. For example, if I filter color by Green and Scale by 1.5, I want to see the bar chart for green move whilst the rest remain the same. I also don't want a bar graph that only shows Green. 

[v-jayw-msft · Accepted solution]

Hi @dli9 ,

Create a new table contains color column and has no relationship with the original table.

Slicer table = distinct(colortable[color])

Then use this table as color slicer and modify the measure as below.

Scaled Volume Measure = 
IF(
    MAX( ColorsTable[ColorsTable]) IN VALUES('Slicer table'[color]), 
    [Raw Volume Total] * [Power BI Scale],
    [Raw Volume Total]
)

Best Regards,

Jay

[dli9]

@v-jayw-msft 

Great, this works. If I filtered by one color and only want to see that color, would I just replace Slicertable [color] with Colorstable[color]. Using the example earlier, if I filter color by Green and Scale by 1.5, I want to ONLY want to see green with the scaled number. 

Scaled Volume Measure = 
IF(
    MAX( ColorsTable[ColorsTable]) IN VALUES('ColorsTable[ColorsTable]), 
    [Raw Volume Total] * [Power BI Scale],
    [Raw Volume Total]
)