Forum Discussion
Weighted Average by Category + Distribution using Multiple Fields
PBI, I am looking to develop a score that takes into account weighted average of two fields, using % distribution based on a category with unique values. I have provided example to show what I am...
kentyler
Solution Sage
Solution SageIt looks like you are visualizing your data structure with the structure of the report you are aiming at. You might need to unpovit the data like this
- kentyler
for example
count sent by method becomes a simple sum
but in the unpivoted data you have to sum up and combine a count for each method
Would this involve a SUMX or COUNTX? I'm confused when to use the COUNTX or COUNTAX function when taking into account both 'Method' and distribution using either send or received for one function.