Issues calculation total over an average calculation

DAX DAX Calculations
1

Hi all,

I’m having trouble with a report in which I want to have the totals over an average calculation. I have read several topics, watch a few EDNA video’s and tried a lot of different ways, but all measures are still giving me the average, while I’m looking for a total.

image
image1836×374 33.1 KB

I dont want 17.46 but I want the sum for 40.03 + 6.67 so 46.70 as a result.
I have attached a sample file and hope somebody can help me with this issue.

Weekly Dummy report.pbix (524.6 KB)

Many thanks,

Kind regards Marieke

2

@marieke

Uren per dag 1 =
SUMX (
    ADDCOLUMNS (
        SUMMARIZE (
            Dummy,
            Dummy[Driver-Wk],
            Dummy[DRIVER],
            Dummy[TRUCK]
        ),
        "Uren", [Uren per dag Avg]
    ),
    [Uren]
)
1 Like
3

Thanks @AntrikshSharma this is exactly what I needed!