Result of filter is different in SQL Server and Power BI

[Lemmon2314]

Hi Guys, i hope you could help me with this one.

I have a report that is connected to SQL Server for the data.

Why is that the result of the filter in Power BI is different in SQL Server ?

- count of records in Power BI and SQL Server is same.

See the screenshots below:

Power BISQL Server

[v-yuezhe-msft]

@Lemmon2314,

Could you please share dummy data of the Incidents table? I will test it in my environment.

Regards,
Lydia

[Seth_C_Bauer]

@Lemmon2314 My first guess would be your condition in SQL that the record be logged in month 1. I don't see that in the DAX filter and this could account for the slight difference in the value especially at the end of the month.

[Lemmon2314]

@Seth_C_Bauer HI Sir, i just do that to see the data in JANUARY only, so that when i highlighten the january, it will show the data only in january which is MONTH(LOGGED DATE)=1 in SQL