Need assistance with the PBI Matrix

[ashmitp869]

Hi there

How can I show this in PBI Matrix

The Logic to consider is in CrewVsRole table

sample file 
https://github.com/suvechha/samplepbi/blob/main/Mockup%20-%20Copy.pbix

@danextian @Ritaf1983@amitchandak @lbendlin @MFelix @Greg_Deckler 

[v-dineshya]

Hi @ashmitp869 ,

Thank you for reaching out to the Microsoft Community Forum.

Hi @danextian  and @MFelix , Thank you for your prompt responses.

Hi @ashmitp869 , Could you please try the proposed solutions shared by @danextian  and @MFelix ?  Let us know if you’re still facing the same issue we’ll be happy to assist you further.

Regards,

Dinesh

[v-dineshya]

Hi @ashmitp869 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh

[MFelix]

Hi @ashmitp869 ,

Not sure if I got the requirement correct but try to add the followind measure:

Validation = 
SWITCH (
    TRUE (),
    NOT ( ISINSCOPE ( NewRules[Employee Code] ) )
        && SELECTEDVALUE ( NewRules[Crew ID] )
            IN { "C003", "C004" }
                , COUNTROWS (
                  FILTER(  ADDCOLUMNS (
                        VALUES ( NewRules[Employee Code] ),
                        "D", [RuleRightToWorkStatus_AllProjectsNR]
                    ), [D] = "Green"
                ) ),
    
        ISINSCOPE ( NewRules[Employee Code] ),
        [RuleRightToWorkStatus_AllProjectsNR]
    
)

Result below and in attach PBIX:

Not sure if this is the result you need but let me know if there is any different result you need.

[ashmitp869]

Thanks for the assistance, the other reply was more appropiate.

[danextian · Accepted solution]

Hi @ashmitp869 

Please see the attached pbix. 

[ashmitp869]

Thanks for the solution. Much appreciated for your assistance.