Forum Discussion
Helper IIIconditional multiply
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.⚡
Helper IIIalso - my apologies, I forgot to mention, for each unique ID, the total value is only mentioned once and in the sub catergory the total is left blank
Super Usershei7141 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
thanks Perry,
It returned the sum of total for each Unique ID
I tried the following (i.e. before multiplying with the new distributional values)
= CALCULATE(MAX(Tab[Total]),ALLEXCEPT(DatabaseTab,DatabaseTab[UniqueID]))- parry2k
shei7141 I have no idea what you mean? Are you adding this a column or a measure? Why not you multiply as I expected, see screenshot below
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
sorry for the confusion
I am calculating a measure.
I want to return New Col (as a measure) = total (per unique ID) x NewDis