Forum Discussion
Helper IMultiple Filters OR on multiple columns from multiple tables
I will have to ask you to provide samples of the MasterList table and at least two of the other participating dimension tables.
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Super Useruse || or IN function to achieve that.
DeeBaliHello,
Thank you for your response. I have not used IN funtion prior to this, may I get some hint on how to write this statement? Thank you.
- lbendlin
It doesn't apply in your scenario. You would use the || operator
NON COMPLIANT = calculate(distinctcount(MasterList[Name]),
AD[In SCCM]="No" ||
SCCM[In AD]="No" ||
Defender[Onboarded]="No" ||Purview[Onboarded]="No" ||
InTune[Onboarded]="No" ||
MasterSecureBaseline[State] ="Yes")
You may need aggregations - depends on your setup.
- DeeBali
Hello,
I tried this code and the errorI recieve is below:
"The expression contains columns from multiple tables, but only columns from a single table can be used in a True/False expression that is used as a table filter expression."