Forum Discussion

calen's avatar
calen
Icon for Helper I rankHelper I
4 years ago
Solved

Help with Totaling

Hello All!    I've got what I feel is a very simple problem but I can't quite figure out how to fix it. Below is a sample Dataset. I am trying to take the normal price - the discount price, then mu...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    calen , I think it should be like

     

    Discount Amount =

    SUMX(Table, ([Unit Price] - [Discount Price])*[Quantity])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

calen , I think it should be like

 

Discount Amount =

SUMX(Table, ([Unit Price] - [Discount Price])*[Quantity])

calen's avatar
calen
Icon for Helper I rankHelper I
4 years ago

amitchandak Thank you for your help! The unit price comes from the item table, the discount price comes from the pricing table table, and the quantity comes from the sales table.  Is there a way to bring all three tables into the measure above?