Exclude value in some cases

[Astolfo]

Hi all,

i have a list of brands with their weekly revenue, i want to show the total revenue of the week but i would like to add something( a filter or something like that) that allows me to show the total with and without Adidas Revenue.

Thanks

[DOLEARY85]

HI,

try:

measure = CALCULATE(SUM('table'[Revenue]),'table'[Brand] <> "Addidas")

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[Astolfo]

It works to exclude adidas revenue, but i was asking a way to exclude and include it, like a filter, total with adidas and without adidas

[DOLEARY85]

Could you use a normal calculate sum measure and add a slicer with the Brand column to adjust the total based on what is selected? 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[Astolfo]

Wanted to avoid it, for me is fine but the final user is really basic about using power bi. 

[DOLEARY85 · Accepted solution]

If it's just Adidas you're going to exclude always you could create bookmarks one with the visual with Adidas one without, then link it to a button for the user to select which view they want.

If this isn't what you need what would be the ideal outcome? how would the report need to look?

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[Astolfo]

I think this is what i need. Many thanks!

[DOLEARY85]

No problem, happy to help 🙂