The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have created a Quick Measure (Weighted Average by Category) which contains percentage values:
The percentage values themselves are correct, but the total (450.70%) is the Sum of the above percentages. I want the Total to be the Average of the avobe percentages.
Normally I would change the summerization from Sum to Average, but I cant seem to do this because it's a measure (I presume).
For context, this is the measure:
Totaal % weighted by Contractuur per HV =
VAR __CATEGORY_VALUES = VALUES('Alle tijd 2022 v2'[HV])
RETURN
DIVIDE(
SUMX(
KEEPFILTERS(__CATEGORY_VALUES),
CALCULATE([Totaal %] * SUM('Contracturen'[Contractuur]))
),
SUMX(
KEEPFILTERS(__CATEGORY_VALUES),
CALCULATE(SUM('Contracturen'[Contractuur]))
)
)
EDIT: When I select multiple months (i.e. January and February), it also takes the Sum of the percentages as opposed to the average. How can i change this?