Forum Discussion
Solved
Need help with counting...
All I want to do is count the occurrences of the Yes values. There are eight rows and 7 Yes values. Why am I getting a count of 15? I'm doing something wrong!
cntSSMYes = COUNTROWS(FILTER('YET SS Matrices','YET SS Matrices'[SSMImproved]="Yes"))
pbrainard ,[SSMImproved] is column it should work
If this is a measure , Try a measure like
cntSSMYes = COUNTX(Filter(Values('YET SS Matrices'[participant]) ,[SSMImproved]="Yes") ,[participant] )
3 Replies
pbrainard ,[SSMImproved] is column it should work
If this is a measure , Try a measure like
cntSSMYes = COUNTX(Filter(Values('YET SS Matrices'[participant]) ,[SSMImproved]="Yes") ,[participant] )
Thank you kindly!!! Worked like a charm.
The formula looks correct.
Is there any filter applied to your matrix here which is limiting the number of rows?
