Help about the slicer between and dynamic sum(amount)

[ahmed_MEJRI]

Hi Experts,

i'm working a report that shows sales by agent (representative of sales site) and i filtred dynamically by the slicer between two dates , the problem that when i verify my work in SQL by a simple query :

select Représentant, sum([Mnt HT]) as sommeCA from Fact_Ventes A

join dm_client B on A.[Code Client]= B.[Id_Client]

WHERE A.[Date] between '2018-01-01' and '2018-12-31'

GROUP BY B.[Représentant]

--> and i find that statistics are not similars between Power BI and SQL server (very different)

really i tried many things but i didn't found solution. But note that i verify statistics for other reports in sql server and it's OK. Really i'm stressed for this abnormal situation.

[v-yuta-msft]

@ahmed_MEJRI ,

I guess 'Mnt_HT' is a measure, right? Could you please share the dax code?

Regards,

Jimmy Tao