Count rows of a filtered table

[christinek]

I have a filtered table which looks like this (filtered on value > $5000):

Manager	Client Name	Value
John	a	$        5,300
John	b	$        5,200
David	c	$        6,500
David	d	$        6,200
David	e	$        5,800
Colin	f	$        7,000

I want a CARD value to show 6 in this example which is the count of the rows.

I have tried adding a MEASURE using COUNTROWS, but not really sure how to add it correctly to factor in the filter if necessessary.

And to complicate it, the "Value" which the table is filtered on is from a different Data table to "Manager" and "Client". I am not sure if this will impact the solution. 

Any help appreciated.

[Ashish_Mathur]

Hi,

Assuming Value is a measure that you have already written, write this measure

Measure = countrows(filter(generate(values(managers[manager]),values(clients[client]))),[Value]>5000)

Hope this helps.

[abpgupta · Accepted solution]

Count1 = CALCULATE(COUNTROWS('Table'), 'Table'[Column3] >= 5000)