A bug with filtering and count

[ruicheng]

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

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

[v-yangliu-msft]

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:

When [Group] is selected:

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

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]

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.

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

Thank You

Dharmendar S

LinkedIN 

[ruicheng]

i used count not count distinct

[ruicheng]

It's count not count distinct