Forum Discussion
Reverse filter for multiple selections
I'm doing analysis on Microsoft 365 licenses assigned to accounts in Entra ID. As some organisations have a requirement for certain license assignments per account, for example O365 E3 and EMS E3, I'...
Thanks, Scott Anonymous . It's working, but only if the user (ID) has only 2 licenses (Desc). It doesn't seem to work if they only have 1 license, or have 3 or more licenses.
From your example, if ID 1 had D as well as A and C, or if ID 4 only had A.
Is there an easy way of accommodating for this scenario?
Thanks, Kath.
Hi Travelling_Kath ,
I'm sorry to say that it doesn't seem to work in my experience. Because there is no such concept as full equality in DAX, either the IN operator or CONTAINSSTRINGEXACT, they both mean containment not full equality.
Best regards,
Community Support Team_ Scott Chang