Forum Discussion
Conditional Formatting - more than one condition from a different table
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
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.