topic Re: How to sum a dax measure in DAX Commands and Tips

How to sum a dax measure

Anonymous — Fri, 19 Mar 2021 09:13:36 GMT

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

Re: How to sum a dax measure

amitchandak — Fri, 19 Mar 2021 10:27:57 GMT

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])

Re: How to sum a dax measure

Anonymous — Fri, 19 Mar 2021 10:43:22 GMT

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