Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Just starting out and this is probably a very basic question but I couldn't find something that really answers this. If there is I appreciate links to those resources in this forum.
I have the following grouped table with two columns, Card Number and Transaction date. I am trying to find a way to only show cards with multiple transactions in a day. For example: Card 2 had three transactions on 4/17/19 and two on 4/12/19 & 4/26/19. So on the report I am thinking just a table visual with card number and transaction date where the transaction date only shows those with multiple entries for that card.
Current Table:
Report visual table showing something like this:
Solved! Go to Solution.
Hi @Anonymous ,
Add a measure with the following code:
Filter = COUNT(Card Number)
Now add this measure to the filter of the table visual you created and select all value above 1 should give expected result.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Anonymous ,
Add a measure with the following code:
Filter = COUNT(Card Number)
Now add this measure to the filter of the table visual you created and select all value above 1 should give expected result.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThis worked perfectly, thank you! I did have to also add the filter of greater than 1 but it was definetly the solution I was looking for. Appreciate the help ![]()
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 98 | |
| 72 | |
| 50 | |
| 47 | |
| 42 |