Forum Discussion
brian0782
Helper II
Helper IICalculate 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])
amitchandak
Super User
Super Userbrian0782 , Assume you have a measure [distinctCOUNT of field]
Try a measure like
AverageX(summarize(Table, [Company], [UMR] , [ImportFileName], "_1", [distinctCOUNT of field]),[_1])
brian0782This worked fantastically - thank you! Can I ask the what the syntax "_1" does?
- amitchandak
brian0782 , In summarize we need to give column names for summarized columns or measure. I usually give _1, _2 kind of name to these columns, so they do mix with main name I have
refer if needed
Summarize - https://www.youtube.com/watch?v=qE5KBp4uP0g