Forum Discussion

shei7141's avatar
shei7141
Helper III
6 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
    6 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.⚡

amitchandak's avatar
amitchandak
Super User
6 years ago

shei7141 , what is expected output. Are these all column.

One solution can be a new column - but I doubt you need that

new column = [Total]*[NewDis]

  • shei7141's avatar
    shei7141
    Helper III
    6 years ago

    Thanks heaps

     

    I want to calculate this as a measure and expecting the return value to be (Total x new Dist)

    • shei7141's avatar
      shei7141
      Helper III
      6 years ago

      also - 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

       
      • parry2k's avatar
        parry2k
        Super User
        6 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.⚡