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
ruicheng
Regular Visitor

A bug with filtering and count

there are some bug for "count" in the tabel visual, see screenshot

ruicheng_0-1724662851034.png

 

in the filter, we can see there are 1159 records (which is correct), but when count Order ID in the visual, it only show 899.

I confirm that every row has a Order ID

 

4 REPLIES 4
Anonymous
Not applicable

Thanks for the reply from dharmendars007 , please allow me to provide another insight: 

Hi  @ruicheng ,

 

You can check if the fields that have a join relationship with [Order ID] are selected in other visuals, which will also affect the [Order ID] Count.

When [Group] is not selected:

vyangliumsft_0-1724726925814.png

When [Group] is selected:

vyangliumsft_1-1724726925816.png

If you want to be unaffected between the two Viszars, you can click on Format – Edith Interlactions.

vyangliumsft_2-1724726959591.png

 

Refer to:

Change how visuals interact in a report - Power BI | Microsoft Learn

If the results above don't meet your expectations, Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

dharmendars007
Super User
Super User

Hello @ruicheng , 

 

Kindly check whether you ahve selected Count or Count Distinct, if the selection is Count Distinct then the number will be less than what it is showing in date filter.

 

You can right click on the measure and check this.

dharmendars007_0-1724663328130.png

If you find this helpful , please mark it as solution and Your Kudos are much appreciated!

 

Thank You

Dharmendar S

LinkedIN 

i used count not count distinct

It's count not count distinct

Helpful resources

Announcements
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