Conditional Formatting - more than one condition from a different table

[Anonymous]

Hello everyone,

Beginning Power BI user, first time poster and all around nice guy here...

I read this thread:
https://community.fabric.microsoft.com/t5/Desktop/Conditional-formatting-based-on-another-table/m-p/...

And I noted vivran22's response that had this example in it:

My question is can these measures have multiple conditions for them?

I have a table that I'd like to use to highlight a field but there are FOUR fields that all have to match for the field to highlight. 

Due to HIPAA policies, I'm unable to share any files so I apologize in advance. 

Thank you!

[Anonymous]

Hi @Anonymous ,

You can try this:

Measure =
SWITCH(
    TRUE(),
    Judgment condition 1 && Judgment condition 2 && Judgment condition 3 && Judgment condition 4， “output1”
    Judgment condition 5， “output2”
)

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

[PijushRoy · Accepted solution]

Yes @Anonymous 

You can you multiple conditions in switch statements from different tables. Please use variable and switch statements.
Like one example

Measure = VAR _1stColumn = SELECTEDVALUE(your column)
VAR _2ndColumn = SELECTEDVALUE(your column)
RETURN
SWTICH(
TURE(),
Condition like you shared image)

I understand you can't share project-specific documents, it makes sense.
Please create a sample record and share it with the expected result. So you get answers quickly
Please ref this article
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

If solves your requirement, please mark it as SOLUTION. Appreciate your KUDOS 

Thanks
Pijush