Total value of Switch(True() measure in Table Visual

[michael_knight]

Hi,

I created a Switch(True() measure and then used it within a table but it's not displaying the correct values in the total column

I believe it may be using the context of the Switch(True() measure within the Total column. 

Switch = SWITCH(TRUE(),
[Margin Measure] >= 100, 1000,
[Margin Measure] >= 80, 500) 

In the example above, I want the Switch columns total to be 5,000 rather than 1000

https://www.dropbox.com/s/yl5ypb8tz8asim7/help%20-%20Copy.pbix?dl=0

Thanks,

Mike

[v-jayw-msft · Accepted solution]

Hi @michael_knight ,

In your sample data you could use ISINSCOPE() function to create a new measure as below.

Measure = IF(ISINSCOPE(Sheet1[Agent]),[Total],SUMX('Date',[Total]))

Best Regards,

Jay

[ryan_mayu]

@michael_knight 

here is a workaround for you

[michael_knight]

Thanks, won't be able to apply that to my main dataset. Do you have any alternatives?