count of filtered output

[prabhuss]

Hi,

I am trying to get count of user who has done more than 3 transactions in a day. For that purpose, I have created Table and Time slicer. Table is showing correct output with respect to Date. Now I am trying to count number of  rows in displayed table but not able to get right DAX to get it done. Below is screen shot. for first case, I want to see count as 8 and in other case count should be 1. Appricate if somebody can help me.

[v-danhe-msft]

Hi @prabhuss,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @prabhuss,

Based on my test, you can refer to below steps:

1.I have entered some sample data.

2.Create a measure.

Count = COUNTROWS('Table1')

3.Create a Table visual, a Card visual and a Slicer. Add the related field and you can see the result.

You can also download the PBIX file to have a view.

https://www.dropbox.com/s/9fp2bn7i4xiaolr/count%20of%20filtered%20output.pbix?dl=0

Regards,

Daniel He

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490