sum product of two columns in powerbi table with dax

0
votes

I would like to get the sum product of this table:

enter image description here

example: (0*.0256) + (1*.0468) + (2*.0344) ...

days to departure is a dimension under one table. And Conversions is a measure that I'm showing as % of Grand Total.

Thanks for any advice.

1
powerbidaxpowerbi-desktop

1 Answers

1
votes

So we have table T with the column [Days To Departure] and the measure [%GT Conversions]

We want a measure to sum all the values of [%GT Conversions] for all the rows of T.

Let's call this measure [Total Formula], since I don't know what it'd be expected to represent

Total Formula = 
VAR Total = SUMX( ALL( T ), T[Conversion] )
RETURN
SUMX( ALL( T ), T[Days To Departure] * T[Conversion] / Total )