Forum Discussion
Solved
Weighted Average Help
Guys I'm really struggling with DAX and weighted Averages. I sort of know what I'm doing in SQL, but I can't translate this into DAX. The new quick measure doesn't seem to work either. I'm tryi...
Hi,
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.
I tried to create a sample pbix file like below.
I suggest having a calendar table like below.
Weight Avg measure: = DIVIDE ( SUMX ( Data, Data[Value proposed] * Data[Rate] ), SUMX ( Data, Data[Value proposed] ) )
Hi,
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.
I tried to create a sample pbix file like below.
I suggest having a calendar table like below.
Weight Avg measure: =
DIVIDE (
SUMX ( Data, Data[Value proposed] * Data[Rate] ),
SUMX ( Data, Data[Value proposed] )
)
Thank you, that's exactly what I was after. I now have to figure out how to put the two sets of results onto one line graph.