Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
User | Count |
---|---|
52 | |
46 | |
20 | |
16 | |
13 |
User | Count |
---|---|
108 | |
54 | |
31 | |
20 | |
18 |