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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi, i'm a new in. I have this table:
where "ORE per Laser" is this measure :
Ore per LASER = CALCULATE(
DIVIDE(
'Riepilogo Ore'[ORE Progressivo Reparti],
[Progressivo Reparti]
),
FILTER(
'Riepilogo x reparti',
'Riepilogo x reparti'[Reparti] = "06F"
)
) + 'Riepilogo Ore'[Ore per connessione]+'Riepilogo Ore'[Ore per ARMADIO]
I want a measure that get the total of Ore per Laser, like 2712.25.
Many thanks to everyone that can help me
@Anonymous , Try a new measure like, if needed relapse Ore per LASER with its calculation
sumx(summarize(Table, Table[Anno], Table[Mese], "_1", [Ore per LASER ]),[_1])
@amitchandak , Thank for your reply, but your measure doesn't work. I tried a measure similar to yours (prova2), it is:
Prova1 = SUMX(VALUES('Riepilogo Ore'[DATE]),[Ore per LASER])But the result is wrong:
What i want is the total sum of Ore per LASER, that is 2712.25.
Ore per LASER is a measure that calculate the ratio between two progressive sum
Check out the November 2025 Fabric update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!