PowerPivot Table - Total Column as a Multiplication of Values

New Contributor

Good afternoon,

I am trying to create an additional total column in power Pivot Table as per the yellow highlighted column in my Snip Below:


The Total Rate is the "Rate" column, multipled by the "Total Hrs";

The Data for Rate for certain Roles is coming from a Lookup table which is linked to a data table containing all of the relevant hours worked by specific roles on specific Dates.


any assistance would be greatly appreciated, thankyou.


5 Replies

@TamlerloversKant Not sure that I have the perfect answer for you, but with a few DAX measures you can somewhat achieve what you want, though you get some extra columns.

See attached.

best response confirmed by TamlerloversKant (New Contributor)


As variant you may add row with Rates moving Values into Rows section


Not to show in each column measure could be

Rate total::=IF( HASONEVALUE( Table1[Date]Table1[Date]), BLANK(), [Rate] )
Thanks Riny, Much appreciated. thats a great option.
Thanks Sergei, thats ideal!