Forum Discussion

Aruljoy's avatar
Aruljoy
Helper II
4 years ago
Solved

Count members based on Measure result

Hi,   I want to count the no of members who has FailOnlyFlag=1. FailonlyFlag is a measure basen columns measure_Successcount & Measure_failcount   FailOnlyFlag = if([Measure_Successcount]=...
Need Help
  • TheoC's avatar
    TheoC
    4 years ago

    Aruljoy you used the wrong measure.  You have = 0 instead of > 0. Please fix your measure and try again.

     

     

TheoC's avatar
TheoC
Community Champion
4 years ago

Hi laurenN 

 

Apologies for the late reply.  I am not sure the two issues align quite as would be required to give you the solution that you're after.

 

Given this is a closed post, can you do me a massive favour and add a new post?  Also, can you just provide a sample of the data that you are dealing with so that I (or another member of our Community) can better understand it and provide a solution efficiently?

 

Thanks heaps and please feel free to tag me in the post or in a comment once you've made the initial post.

 

Theo 🙂

 

laurenN's avatar
laurenN
Regular Visitor
4 years ago

TheoC Thank you so much for getting back to me - I managed to somehow find a solution yesterday in the end - perhaps not as elegant as it could be but it does the job - I used this:

and it's giving me the desired results.  Thank you so much for your time anyway though Theo, I appreciate it

  • TheoC's avatar
    TheoC
    Community Champion
    4 years ago

    laurenN  love it! Well done on getting a solution!