Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

How to sum a dax measure

Hi, i'm a new in. I have this table: 

saretta_1-1616144500643.png

 

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

2 REPLIES 2
amitchandak
Super User
Super User

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

Anonymous
Not applicable

@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:

saretta_0-1616150325071.png

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

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.