Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Visual to only show multiple entries of same date and ID

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:

2019-05-09 13_47_51-Clipboard.png

Report visual table showing something like this:

2019-05-09 13_50_13-Clipboard.png

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

2 REPLIES 2
MFelix
Super User
Super User

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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Anonymous
Not applicable

This 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 Smiley Very Happy

 

 2019-05-09 16_13_19-Untitled - Power BI Desktop.png                   2019-05-09 16_15_41-Untitled - Power BI Desktop.png

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors