Matrix correct dax solution

[azaterol]

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

 As you can see I have in my Matrix row the SaNr and in my Matrix value the August measure.

For 4400 I want the measure calculate with salary2, like this:

August = calculate(SUM(DOK[salary2]),filter(DOK, DOK[DokDate]>=date(2022,08,01) && DOK[DokDate]<=date(2022,08,30)))

But as you know, I only can use one measure for an value

As you can see I have in my Matrix row the SaNr and in my Matrix value the August measure.

 

The Result calculates for both SaNr(4300 and 4400) with salary1, but 4400 shoul calculate with salary2. How can I do this?

Thank you for help

[v-xiaotang]

Hi @azaterol 

Thanks for reaching out to us.

I just want to confirm if you resolved this issue? If yes, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

If you need more help, please let me know.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[tamerj1]

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

[calerof]

Hi @azaterol ,

I'd be happy to help if you provide sample data please.

Fernando