Forum Discussion
Comparing data from two slicers
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:
- Connected my product master with sales table using item as key
- Created a seperate brand table from the product master with no relationships with any table
- Create a measure:
Calculate ( sum (sales), filter (Product master, Product Master [Brand] in {selectedvalue (Brand [Brand])})
- Selected Brand from first slicer (Brand column from product master) and Brand from 2nd slicer (Brand from brand table
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.
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.⚡
3 Replies
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.⚡
Thanks a lot!!!!!
Can you please elaborate why my selectedvalue didn't work? Also, how TREATAS played a role in fixing the data?
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.
