Forum Discussion

azaterol's avatar
azaterol
Helper 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)))

 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

Need Help

3 Replies

  • tamerj1's avatar
    tamerj1
    Community 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 )
        )
    )
)
  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    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.