Forum Discussion

nh27's avatar
nh27
Helper III
4 years ago
Solved

Calculate discount using two tables

Hi fellow BI users, I need your help! I am trying to create a measure called Discount which takes the discount value from a table "Discount_Lookup" and applies it to the row in "ZSALES" table....
Need Help
Show and Tell
Tips and Tricks
  • VahidDM's avatar
    VahidDM
    4 years ago

    HI nh27 

     

    Can you share a sample of your data (both tables)?

    BTW, try this:

     

    Discount = SUM(Zsales[Subtotal1])*MAX(Discount_Lookup[Discount])

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

    Appreciate your Kudos!!

     

YukiK's avatar
YukiK
Impactful Individual
4 years ago

Use SUMX() instead of SUM(). Your measure will look like something like this:

 

Discount = SUMX(Zsales, Zsales[Subtotal1])*RELATED(Discount_Lookup[Discount]))

 

Please give it a thumbs up if this helps!