I have a table called "List" with two column...Name, and Team such as this:
I would like to create a measure to count the number of Names (rows) that belong to the same Team as the name slected in a slicer.
For example, I have a slicer for the Name column... If I select Charlie from that slicer, I could like a measure to output 3 because Charlie is in team B and there are 3 Names in team B.
I have the following DAX: CALCULATE (COUNTROWS('List'),FILTER('List','List'[Team]=SELECTEDVALUE('List'[Team])))
But it isn't calculating correctly.
Go to Solution.
[Team Count] =
var __oneNameSelected = hasonefilter ( T[Name] )
var __teamCount =
countrows ( T ),
all ( T ),
values ( T[Team] )
View solution in original post
Learn how to create your own user groups today!
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!