Calculate all color product except "blue" on a visual card

DAX DAX Calculations
1

Hello all
I want to calculate all sales for all produts except produt = “blue”, but i want all the red, white and black products.
I believe i could have the value of filter in red, white and black, but the thing is that there are too many colors and i don’t know which and how many, that’s why i need to calculate all the values for all colors except “blue”.
apagar

In this example, my measure should show 160.
Another thing: this visual is in a report with a Year as a filter.
Thanks a lot
Pedro

2

Hi @pedroccamara. Please provide your work-in-progress PBIX and the formatted DAX of the measure you’ve drafted for your card visual.
Greg

3

Hey @Greg
I don’t want you to do this measure for me. Just want to know if there’s any function that does what i need, with the example I have attached. I don’t have any measure to show you.
I believe i could do something like :
Calculate Sum (sales) ALL employees - Calculate sum (sales) filter “blue”.
But i guess there’s a simpler way to do it, no?

4

@pedroccamara,

You are on the right track. Just Calculate your Total Sales, and the use something like Table[Color] <> “Blue”. That should do the trick.

Thanks
Jarrett

2 Likes
5

@JarrettM
I’M SO STUPPID !!!
Of course!!! Let me get back to you on this (out of office)
Thanks a lot Jarret!