Forum Discussion

jvelling's avatar
jvelling
Frequent Visitor
4 years ago
Solved

Measure does not add up in matrix visual

Hi there,   I would like to calculate the total amount of contract hours per filtered time period. The following table is connected to an employee table, which in turn, is connected to other tables...
Need Help
  • HoangHugo's avatar
    HoangHugo
    4 years ago

    Hi, to sum up value within rows, try this one

    ContractHours = 
    SUMX(SUMMARIZE (Datum column),
    CALCULATE(
        SUM(Contracten[ContractUrenPerDag]), 
        FILTER(
            Contracten,
            Contracten[StartDatum] <= FIRSTDATE(Kalender[Datum])
            && Contracten[EindDatum] >= LASTDATE(Kalender[Datum])
        )
    ))
HoangHugo's avatar
HoangHugo
Solution Specialist
4 years ago

Hi, to sum up value within rows, try this one

ContractHours = 
SUMX(SUMMARIZE (Datum column),
CALCULATE(
    SUM(Contracten[ContractUrenPerDag]), 
    FILTER(
        Contracten,
        Contracten[StartDatum] <= FIRSTDATE(Kalender[Datum])
        && Contracten[EindDatum] >= LASTDATE(Kalender[Datum])
    )
))