Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello
I wanna get the count of rows from fact table not equal to fact table[column1] value "Assigned" as well as not equal to EmployeeCategory value "Consultant". I am stuck with that one because these are different tables and PBI does not allow me to make OR operator
can you present data sample or tables structure and define the columns you use?
Also PBI has " || " as OR operator and " &&" as AND operator within functions.
User | Count |
---|---|
84 | |
69 | |
69 | |
65 | |
54 |
User | Count |
---|---|
93 | |
93 | |
91 | |
76 | |
69 |