set analysis

[Giwa_Temitopoluwa]

I have issues with using set analysis to get a count of the values in a column of Yes and No,I need the count of Yes...What am I doing wrong?

[Or]

Other than the use of double quotes instead of single quotes, it looks fine, and that shouldn't change the result.

[Giwa_Temitopoluwa]

I saved it as a master item ,then tried to use it in a KPI but it's giving a dash

And this is what I get when I used same expression but different values

[Giwa_Temitopoluwa]

I saved it as a master item ,then tried to use it in a KPI but it's giving a dash

And this is what I get when I used same expression but different values

[Or · Accepted solution]

I'd suggest confirming that your values are actually Yes and No (with the correct lower/uppercase), and that this is a master measure (and not a dimension). You could also troubleshoot by replacing the 'Yes' with * (all values) and see if that count works, or by replacing the set with a matching if() statement.

[BrunPierre]

Try these

Count(IF(WildMatch(Ordered, '*Yes*'), Ordered))

or

Count({<Ordered= {"*Yes*"}>}Ordered)

[edwin]

follow what @Or suggested, try replacing the double quotes with single quotes