Forum Discussion

RLSid17's avatar
RLSid17
Helper III
3 years ago
Solved

Count Values Out Of Total

Hi, Is there a way to count the values and compare them to another table? Kinda like for example, 24 out of 30 employees responded to the survey. I have a table that is similar to this: ...
Need Help
  • RLSid17's avatar
    RLSid17
    3 years ago

    Hi v-yanjiang-msft 

    Thank you for your response, I managed to resolve it now by counting the users and then also counting the total number of users.


    There are 2 datasets, where I got the distinct count of responses and then compared it to another table which has the number of employees per manager. 

    Just for the benefit of others, all I had to do is to make a relationship between the two datasets to get the required value like the one I'm doing.

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
3 years ago

Hi RLSid17 ,

According to your description, if you just want to count the numbers of each category, simply put the Category column in a visual twices then select Count in drop-down box. Get the result:

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.