Forum Discussion

Omega's avatar
Omega
Impactful Individual
5 years ago
Solved

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 sal...
Need Help
Show and Tell
Tips and Tricks
  • parry2k's avatar
    parry2k
    5 years ago

    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.⚡

parry2k's avatar
parry2k
Super User
5 years ago

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.