Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I'm having trouble getting an averagex function to work correctly, my data has one row per person, I need a function that checks a flag column then choses which column to sum as appropriate.
At the moment it seems to be evaluating for more than one person at a time as I'm getting an error about multiple values. Code is below, can anyone sugest a solution?
=AVERAGEX ( VALUES ( table[Person_ID] ), IF ( values(table[flag]) = 1, sum( table[Col1] ), sum(table[Col2]) ) )
Than you
MyAverageX = AVERAGEX(table,IF(table[flag]=1,table[Col1],table[Col2]))
As a measure.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |