Forum Discussion
Helper Icount of filtered output
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.
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
3 Replies
- Greg_Deckler
Community Champion
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
v-danhe-msftMicrosoft Employee
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
- 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
