Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
Other than the use of double quotes instead of single quotes, it looks fine, and that shouldn't change the result.
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
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
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.
Try these
Count(IF(WildMatch(Ordered, '*Yes*'), Ordered))
or
Count({<Ordered= {"*Yes*"}>}Ordered)
follow what @Or suggested, try replacing the double quotes with single quotes