Switch function not working

[knowledgegarage]

I have an interesting problem. To date I have successfully applied the SWITCH function to SUM measures based on a tables containing the name of the measure.

However there are two measures that pull through blank and I cannot figure out why as when I drop the individual measures into a column they work. Perplexing as every other measure (over 50) works

'Measure Test' table (Title is 'Test Measures'):

Total (Scope 1+2) Emissions Intensity per EUR million Sales (t/EUR million sales) (PVA)

Total (Scope 1+2) Emissions Intensity per USD million Sales (t/USD million sales) (PVA)

Measure Calculation:

Weighted Average Measure =

SWITCH(TRUE(),

"Total (Scope 1+2) Emissions Intensity per EUR million Sales (t/EUR million sales) (PVA)"

IN ALLSELECTED('Measure Test'[Test Measures]),

SUM('Master Table'[Total (Scope 1+2) Emissions Intensity per EUR million Sales (t/EUR million sales) (PVA)]),

"Total (Scope 1+2) Emissions Intensity per USD million Sales (t/USD million sales) (PVA)"

IN ALLSELECTED('Measure Test'[Test Measures]),

SUM('Master Table'[Total (Scope 1+2) Emissions Intensity per USD million Sales (t/USD million sales) (PVA)])

)

[knowledgegarage · Accepted solution]

So, this is quite strange. I was messing around this morning.

I double checked the names of the respective measures and the formula. Still not working.

I then renamed the measures (slightly different) and altered the formula. It now works, I don't understand why.

[v-easonf-msft]

Hi, @knowledgegarage 

If a BLANK value is returned, this means there are no matches. Please recheck each condition for incorrect measure name.

Also, see if feature  field parameter  in the new version of PowerBI can work for you.

Best Regards,
Community Support Team _ Eason