Forum Discussion

francesg's avatar
francesg
Icon for Helper I rankHelper I
4 years ago

How to multiply 2 aggregated columns the matrix table

Hi Power BI Users   I am not a super expert in Power BI; multiplying two columns sounds easy, but then I could not get the right answer from 2 columns in the same table. I need to get the Price va...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

francesg , if you are creating a column

New Column = table1[cost] * table1[Quantity]

 

 

If you want a measure
New Measure = Sumx(table1,table1[cost] * table1[Quantity])

  • francesg's avatar
    francesg
    Icon for Helper I rankHelper I
    4 years ago

    Hi amitchandak 

     

    I appreciate your reply.

    I have tried those column creations - but with no success. 

    some of my columns have aggregate (max and sum) to hide the Item duplicates.

    Is this possible that I could not get a simple multiply of 2 tables?

    • v-yueyunzh-msft's avatar
      v-yueyunzh-msft
      Icon for Community Support rankCommunity Support
      4 years ago

      Hi, francesg 

      You can click "New measure" to create a measure :

      New Measure = Sumx(table1,table1[cost] * table1[Quantity])

      With this dax, do not select "New Column" because measure is calculated in the current filtering context.

       

      If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.

       

      Best Regards,

      Aniya Zhang

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

       

       

      • francesg's avatar
        francesg
        Icon for Helper I rankHelper I
        4 years ago

        v-yueyunzh-msft 

        Thank you so much for looking into my problem.

        I will send my sample data and data model for you to try as well if you have time.