Forum Discussion

nh27's avatar
nh27
Icon for Helper III rankHelper 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
Icon for Impactful Individual rankImpactful 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!