Forum Discussion

san_bxl's avatar
san_bxl
New Member
1 year ago

Multiple OR condtions within calculate

I have to write a DAX which filters data from three connected tables. table 1. Project Resource Assignemnet table 2.Project Resource table 3,Project_activity I need to now get a sum from Resou...
DAX
San_Raz's avatar
San_Raz
Frequent Visitor
1 year ago

I am looking for
condition 1 or Condition 2 or Conditon 3
If it satisfies any, its should calculate

Poojara_D12's avatar
Poojara_D12
Icon for Super User rankSuper User
1 year ago

San_Raz 

Can you try this dax:

M11-2a_Scope =
CALCULATE(
    SUM('Project-Resource Assignment'[PlannedUnits]),
    ALL('DATE TABLE'),
    
    // Combine Condition 1, 2, and 3 with OR logic
    OR(
        // Condition 1
        'Project-Resource'[Id] IN {
            "C3-GAD-14",  
            "C3-GAD-12",  
            "C3-GAD-13",  
            "C3-GAD-11",  
            "C3-GAD-2",  
            "C3-GAD-1",  
            "C3-GAD-7",  
            "C3-M-9"
        },

        // Condition 2
        AND(
            'Project-Resource'[Id] = "C3-M-102",
            LEFT('Project-Activity'[Id], 14) = "CM-"
        ),

        // Condition 3
        AND(
            'Project-Resource'[Id] = "C3-M-88",
            LEFT('Project-Activity'[Id], 14) = "CM-S3"
        )
    )
)

 

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS