Forum Discussion
Solved
Calculate Average based on Multiple Columns
Hi I have the following dataset in PBI but struggling to find a way to calculate the average across multiple columns. For example, the below average is 15.96 based on the distinct count of fi...
brian0782 , Assume you have a measure [distinctCOUNT of field]
Try a measure like
AverageX(summarize(Table, [Company], [UMR] , [ImportFileName], "_1", [distinctCOUNT of field]),[_1])
I tried to use the meaure suggested above but it did not work. Any guidance on this.
I'm trying to calculate Average based on multiple colums. data in available in the link below.
Need help with measure to calculate Average_Engagement score based on two columns (company and campaign)
| Company | Campaign | Average_Engagement score |
| J | Sun | 25% |
| J | Mon | 30% |
| J | Tue | 40% |
| J | Wed | 60% |
| J | Thu | 70% |
Any guidance will be greatly appreciated.