Is there an equivalent to COUNTIFS based on dynamic value from a slicer input in DAX?

[Hodor]

Hello,

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.

Please Help!

[Anonymous · Accepted solution]

[Team Count] =
var __oneNameSelected = hasonefilter ( T[Name] )
var __teamCount =
	calculate(
		countrows ( T ),
		all ( T ),
		values ( T[Team] )
	)
return
	if(
		__oneNameSelected,
		__teamCount
	)

Best

Darek

[Hodor]

Thank you!!