Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Hi guys,
Can you please help me, I´m trying to do this efficiency formula
"% EFICIENCIA =
VAR _a =
SUMMARIZE (
'pcc',
'pcc'[Hora inicial],
'pcc'[No. Unidades en la hora],
'pcc'[Linea de empaque]
)
VAR _b =
ADDCOLUMNS (
_a,
"%",
IF (
( [tiempo teorico] / (sum(pcc[Total de horas])*60) > 100),
"0",
( [tiempo teorico] / (sum(pcc[Total de horas])*60)
)
))
RETURN
SUMX( FILTER ( _b, (sum(pcc[Total de horas])*60) <> 0 && [tiempo teorico] <> BLANK () ), [%] )"
But the formula sometimes shows me values over 100%, and this alters my reports.
How can I include the condition that if the result is over 100%, it shows 100% and no more?
Hope you guys can help me!
Regards,
Valentina
Hi,
I am not sure how your datamodel looks like but please try something like below.
I assume [tiempo teorico] is a measure, not a column.
"% EFICIENCIA =
VAR _a =
SUMMARIZE (
'pcc',
'pcc'[Hora inicial],
'pcc'[No. Unidades en la hora],
'pcc'[Linea de empaque]
)
VAR _b =
ADDCOLUMNS (
_a,
"%",
IF (
[tiempo teorico]
/ ( CALCULATE ( SUM ( pcc[Total de horas] ) ) * 60 ) > 100,
"0",
[tiempo teorico]
/ ( CALCULATE ( SUM ( pcc[Total de horas] ) ) * 60 )
)
)
RETURN
SUMX (
FILTER (
_b,
CALCULATE ( SUM ( pcc[Total de horas] ) * 60 ) <> 0
&& [tiempo teorico] <> BLANK ()
),
[%]
)
User | Count |
---|---|
8 | |
8 | |
5 | |
5 | |
3 |