Use a card to count filtered rows in a visualisation

[pickslides]

As my filters are being used I want the bottom right hand Card to display how many values are in the left hand side table. My table value is a measure of one metric being divided by another. 

Currently trying to use countrows but retunrs a number that is too large. 

Q

[pickslides]

Thanks for this formula. I did this and it did work but didnt count the rows properly. 

Q

[Seanan]

Hi @pickslides 

Could you please share the expected result and the result you got from the formula? 

[pickslides]

Thanks. Please see, result should be 14, my measure in the table is value / mark

[Ashish_Mathur · Accepted solution]

Hi,

Try this measure

=countrows(filter(values('UnpivotGMA'[First Name]),[value divided by mark]>0))

If it does not help, then share the link from where i can download your PBI file.

[Seanan]

Hi @pickslides 

You can create a measure using the following code:

Count = COUNTROWS(ALLSELECTED(SalesTeam[Company]))

Instead of Company you can use your First name column.