Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I've checked multiple videos and posts on the same topic but I'm unable to reach the result I'm looking for. Basically, I have a product master that has item codes and brand, along with a sales table at item customer level. I want to compare 2 selected brands at customer level, where the user will choose 2 different brands from 2 different slicers.
Steps I took:
Calculate ( sum (sales), filter (Product master, Product Master [Brand] in {selectedvalue (Brand [Brand])})
The challenging I am facing is that my measure keeps getting me the total sales of brand 1 selection instead of brand 2.
Please assist.
Solved! Go to Solution.
@Omega for brand 2 sales you need to do this
Brand 2 Measure =
CALCULATE (
SUM ( Table[Sales] ),
ALL ( Product ),
TREATAS ( VALUES ( BrandTable[Brand] ), Product[Brand] )
)
Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Omega hmm SELECTEDVALUE could have worked but the core is to remove the filter from the product table. TREATAS is basically filtering the product table. Also, TREATAS would work in case you have multiple brands selected whereas SELECTEDVALUE only works if a single value is selected which might be ok in your case.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Omega for brand 2 sales you need to do this
Brand 2 Measure =
CALCULATE (
SUM ( Table[Sales] ),
ALL ( Product ),
TREATAS ( VALUES ( BrandTable[Brand] ), Product[Brand] )
)
Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Thanks a lot!!!!!
Can you please elaborate why my selectedvalue didn't work? Also, how TREATAS played a role in fixing the data?