PowerPivot Table - Total Column as a Multiplication of Values

[TamlerloversKant]

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.

[#2]

@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.

[#3 · Accepted solution]

@TamlerloversKant 

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] )

[#4]

Thanks Riny, Much appreciated. thats a great option.

[#5]

Thanks Sergei, thats ideal!

[#6]

@TamlerloversKant , glad to help