I have a rank table as below which is merged with my FactTable. Previous_Amount works find until I select 2 non consecutive FYandFWOnum number.

I have a sample data as below and I would like to create a powerbi card. The dax code should first groupby based on Source and add the sum of max(FYandFW). How to get around with this ?

I am trying to create a custom tooltip, using the code below. And I would like to align to the Result to the left. many thanks in advance.

I would like to find the MAX(FYandFW num) based on each Source.

how to leverage the code below based on the expected answer, using lastnonblankvalue,Hasonevalue or something relevant rather then MAX()? many thanks in adcance.

I have two dax code below working perfectly,

The code below calculates the Current Week Amt for the latest Fiscal Week num = 52 available. But it fails to calculate the latest Fiscal Week num available based on the Source File.

Carrying on from my previous question  here  
I still do not understand why pbi desktop table visual not giving the same result as per daxstudio.

Have debugged successfully a calculated column with daxstudio. But the same code chunk in
power bi deskstop result is different?