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.
Why does PBI not allow users to use the SUM and AVERAGE functions with measures? I feel like no matter if I create a measure or column, I should be able to do things like:
SUM(Any measure/column I want)
AVERAGE(Any measure/column I want)
This setback is getting in the way of a lot of things I'm trying to figure out...
Solved! Go to Solution.
@Anonymous
To aggreagte a MEASURE we typically use an X iterator
i.e. this pattern
Sum of a MEASURE = SUMX ( ALLSELECTED ( TableName[ColumnName] ), [Measure] )
Check out this recently posted question as well
@Anonymous
To aggreagte a MEASURE we typically use an X iterator
i.e. this pattern
Sum of a MEASURE = SUMX ( ALLSELECTED ( TableName[ColumnName] ), [Measure] )
Check out this recently posted question as well
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |