Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, Please help. I'm stuck . . . .
I have 3 %ages created from measures. I can use a standard calculation to find the mean(adding all 3 percentages then divide by 3) as the Overall score. However, where one of the %ages is zero(eg 90%, 82%, 0%), I need to have a measure to execute the mean excluding %ages with zero and instead find the mean for the 2 %ages. How can I create this in Power BI (Please bear in mind that my percentages are calculations from measures)?
Solved! Go to Solution.
@Anonymous, try the measure below. Insert your actual measure names in the first three variables.
Percentage Mean =
VAR vMeasure1 = [Measure 1]
VAR vMeasure2 = [Measure 2]
VAR vMeasure3 = [Measure 3]
VAR vNumerator = vMeasure1 + vMeasure2 + vMeasure3
VAR vMeasure1HasValue =
IF ( vMeasure1 = 0, 0, 1 )
VAR vMeasure2HasValue =
IF ( vMeasure2 = 0, 0, 1 )
VAR vMeasure3HasValue =
IF ( vMeasure3 = 0, 0, 1 )
VAR vDenominator = vMeasure1HasValue + vMeasure2HasValue + vMeasure3HasValue
VAR vResult =
DIVIDE ( vNumerator, vDenominator )
RETURN
vResult
Proud to be a Super User!
@Anonymous, try the measure below. Insert your actual measure names in the first three variables.
Percentage Mean =
VAR vMeasure1 = [Measure 1]
VAR vMeasure2 = [Measure 2]
VAR vMeasure3 = [Measure 3]
VAR vNumerator = vMeasure1 + vMeasure2 + vMeasure3
VAR vMeasure1HasValue =
IF ( vMeasure1 = 0, 0, 1 )
VAR vMeasure2HasValue =
IF ( vMeasure2 = 0, 0, 1 )
VAR vMeasure3HasValue =
IF ( vMeasure3 = 0, 0, 1 )
VAR vDenominator = vMeasure1HasValue + vMeasure2HasValue + vMeasure3HasValue
VAR vResult =
DIVIDE ( vNumerator, vDenominator )
RETURN
vResult
Proud to be a Super User!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |