Forum Discussion
Post PartisanUsers who have all defined value
Hello All, The following image is a part of a Dataset. First, How to find the user or users that have all certifications. Then show the user or users with their company name in a visual table. If no user has all certifications the visual table would be blank.
Second how to find how many users have all certifications.
Third, how to find the number of users who have at least one certification and more. And their names and companies.
Fourth, how to find users with a different mixture of certifications. For instance, the users have certification A AND B AND F. or A AND C AND F. Or B AND C. Or any mixture.
Is it possible to build a certification slicer that can use "AND" operator between certifications for a user table?
Thank you Samarth, Sorry for delay. How do you think about the following DAX?
User All Cert =VAR K =Countrows(filter(values('Sheet1'[Certification]),LEFT(Sheet1[Certification],4)="Cert"))ReturnIF(K = CALCULATE(count(Sheet1[Certification]),LEFT(Sheet1[Certification],4)="Cert",ALLEXCEPT(Sheet1,Sheet1[User])),1,0)
3 Replies
Samarth_18Community Champion
HI koorosh ,
Please refer below sample file for your file. Please let me know if you need any further clarification.
Thanks,
Samarth
- koorosh
Thank you Samarth, Sorry for delay. How do you think about the following DAX?
User All Cert =VAR K =Countrows(filter(values('Sheet1'[Certification]),LEFT(Sheet1[Certification],4)="Cert"))ReturnIF(K = CALCULATE(count(Sheet1[Certification]),LEFT(Sheet1[Certification],4)="Cert",ALLEXCEPT(Sheet1,Sheet1[User])),1,0)
- koorosh
Hello Samarth, check the attachment, there is some problem with your solution.
https://drive.google.com/file/d/1QVyXfqmJ7xpo921a0b7BHdX0PoZBF3uL/view?usp=sharing