Forum Discussion

jofoster's avatar
jofoster
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Count rows in a table visual that is filtered by a count

I have a table visual that is showing data for all the users who have more than 1 Team.  I filter that visual to only show the data where the count of teams is greater than 1. I want to get a count o...
Need Help
AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
5 years ago

Create a measure for Count Users:

 

Count Users = DISTINCTCOUNT(Usertable[User])

 

This should respond to any filters you apply. 

 

If all your data is in one table though and you don't have a User table you'll need more DAX. Please send screenshot of your model relationships veiw if that is the case.