Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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 👍
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 👍
Wanted to avoid it, for me is fine but the final user is really basic about using power bi.
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 👍
I think this is what i need. Many thanks!
No problem, happy to help 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
109 | |
89 | |
76 | |
66 |
User | Count |
---|---|
126 | |
112 | |
99 | |
82 | |
73 |