Forum Discussion

azaterol's avatar
azaterol
Icon for Helper V rankHelper V
4 years ago

Matrix correct dax solution

Hey all,   in my matrix I have a measure for "August" which is : For 4300: August = calculate(SUM(DOK[salary1]),filter(DOK, DOK[DokDate]>=date(2022,08,01) && DOK[DokDate]<=date(2022,08,30)))  ...
Need Help
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi azaterol 

please try

August =
IF (
    SELECTEDVALUE ( DOK[SaNr] ) = "4300",
    CALCULATE (
        SUM ( DOK[salary1] ),
        FILTER (
            DOK,
            DOK[DokDate] >= DATE ( 2022, 08, 01 )
                && DOK[DokDate] <= DATE ( 2022, 08, 30 )
        )
    ),
    CALCULATE (
        SUM ( DOK[salary2] ),
        FILTER (
            DOK,
            DOK[DokDate] >= DATE ( 2022, 08, 01 )
                && DOK[DokDate] <= DATE ( 2022, 08, 30 )
        )
    )
)