Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |