The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
17 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
12 | |
9 | |
8 |