Forum Discussion

shei7141's avatar
shei7141
Helper III
5 years ago
Solved

conditional multiply

Hi all,   I have a table which looks like the following   UniqueID Sub Total OriginalDis NewDis NewRate 1 1a 500 10% 20% Total x NewDis per Unique ID 1 1b   50% 40%   1...
Need Help
  • parry2k's avatar
    parry2k
    5 years ago

    shei7141 here is the formula, add new column

     

    New Col = CALCULATE ( MAX ( 'Table'[Total] ), ALLEXCEPT ( 'Table', 'Table'[UniqueID] ) ) * 'Table'[NewDis]

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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

shei7141 the solution I posted will get you this, isn't it? Did you try it?

shei7141's avatar
shei7141
Helper III
5 years ago

yes I tried both solution but they did not work

 

your first solution sumed the total and than applied the NewDis

second one only calculated the RevisedFee where Total had some number, 

 

 

  • parry2k's avatar
    parry2k
    Super User
    5 years ago

    shei7141 not exactly sure about your comment on the first one, why not put a pbix file with sample data and both the solution I provided and share it with me.