Power BI dax question please

[DavidP07]

Hi guys, I know this is not a specific question for Alteryx but I'm having trouble adding a second filter to this Dax formula, this is to count the total number of answers in a survey with two criteria.
This is my first string to count exactly "Werewolf, Boggart, Basilisk" AND this is the other one "Werewolf, Basilisk, Boggart", I know, it only changed the second name to last but that needs to be counted as well, and with my original formula is excluding that count.

I used the calculate and filter and the count return for ex 128 but I realized I needed to include a second filter that returns a separate count.
for ex 40 and both results needed to be added so they could give me a total of 168.



I will appreciate all your help, thanks a lot.

[DavidP07 · Accepted solution]

I forgot to mention that both Criteria "Werewolf, Boggart, Basilisk" AND "Werewolf, Basilisk, Boggart", are in the same column

[Qiu · Accepted solution]

@DavidP07 
This is indeed not an Alteryx Question. Wondering what brought you here. 😁
Wide guess only.

https://community.fabric.microsoft.com/t5/Desktop/How-can-I-use-an-OR-function-inside-an-IF-statemen...

[DavidP07]

hahaha thanks a lot, yes, this is only Alteryx, but for this project I was using Alteryx for Prep and Power  Bi for viz in this case because it was requested. Thanks for your help.

😁