Forum Discussion
Exclude value in some cases
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
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 👍
7 Replies
HI,
try:
measure = CALCULATE(SUM('table'[Revenue]),'table'[Brand] <> "Addidas")
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
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
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 👍
