Forum Discussion
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...
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.⚡
shei7141 you replies are very confusing, in the last reply you inked the values which were already possible from my first solution. kind of confusing what you actually want
thanks mate
but with your suggestion also, the return value was 'blank' where the total value was not filled.
Ta,
Shei