Forum Discussion

coolshib's avatar
coolshib
Icon for Helper III rankHelper III
7 years ago
Solved

Dax Measure with related Table

Hello Everyone,   I am looking for a dax measure function based on the following logic.   I have three tables,   Table No.1 Category           Online Price         Offline Price Laptop       ...
Need Help
  • ChandeepChhabra's avatar
    ChandeepChhabra
    7 years ago

    Hi coolshib,

     

    Please establish a relationship between 3 tables and try the following measure for

     

    Total Sales =SUMX(Table3,IF(Table3[Mode]="Online",RELATED(Table1[Online Price]),RELATED(Table1[Offline Price]))*Table3[Qty])

     

    Here is the snapshot of the output

     

     

    You can download the Power Pivot file from here

     

    Hope it helps

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    You may download my PBI file from here.

     

    Hope this helps.

     

ChandeepChhabra's avatar
ChandeepChhabra
Icon for Impactful Individual rankImpactful Individual
7 years ago

Hi coolshib,

 

Please establish a relationship between 3 tables and try the following measure for

 

Total Sales =SUMX(Table3,IF(Table3[Mode]="Online",RELATED(Table1[Online Price]),RELATED(Table1[Offline Price]))*Table3[Qty])

 

Here is the snapshot of the output

 

 

You can download the Power Pivot file from here

 

Hope it helps

 

coolshib's avatar
coolshib
Icon for Helper III rankHelper III
7 years ago

Thank you Mr.Chhabra ( ChandeepChhabra ) for the solution. It works like a charm.

I have one more query regarding this issue, what if i have more than two modes of payment like "Online Transfer, Cash Payment, Credit Card, Debit Card" etc instead of "Offline & Online only".

 

Thank you so much for your promt reply.

 

Best Regards

Shib