Search code examples
powerbidaxvisualizationpowerbi-desktopmeasure

Calculating a total in Power BI for a measure column

I have data in power bi which looks like this:

enter image description here

The total column is a measure which simply takes on hand qty times average value. How can I show the total of the "Total" Column as a sum instead of using a calculation of 19491 x 0.74 = 14390.86. The total of the column should look like this:

enter image description here

Appreciate any help

Solution

  • enter image description here

    total = SUMX('Table', 'Table'[Qty on Hand] * 'Table'[Average Value])