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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
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
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.