Totals not showing with Measure

[Anonymous]

Hi Community,

Hope you can help again. I am struggling with the following: 

I have an entry table for sales with a Source No and an Item.

Item	Date	Sales Amount (LCY)	Source
111	1/1/2022	150	John Doe
111	5/1/2022	350	John Doe
222	5/1/2022	1150	John Doe

Now I've created a measure to calculate the Sales Amount in USD (from USD).  This pulls from a seperate Exchange rate table.

Sales in USD = 
var _date = SELECTEDVALUE('Sales'[Date])
var _rate= CALCULATE(MAX('Ex Rate'[Rate]),FILTER('PS NL Ex Rate','Ex Rate'[Starting Date]<= _date && 'Ex Rate'[End Date]>_date))
var _turnover = CALCULATE(SUM('Sales'[Sales Amount (LCY)])*_rate)

RETURN
_turnover

This gives me some weird results however. For Source ADEMCZ the totals are not shown:

As you can see for some Source No. the totals are calculated. Please not that this matrix shows the totals for January 2022. 

If I look at the underlying lines I can see that the rate is applied correctly for each line but there is no total:

Please let me know any suggestions, I've been scratching my head around this for quite some time now. 

Kind Regards,

Koen

[HoangHugo]

hi,

var _date = SELECTEDVALUE('Sales'[Date])

It will return Blank in your total row, so your total can not be calculate. Other total have result, i think due to you only have one transition in the items.