How to calculate/show rowtotal

[LotteLaugesen]

Hi
How do I get a Total for Actual in this table? 

Actual =
VAR startDate_ = SELECTEDVALUE( 'Products'[Start date])
VAR endDate_ = EDATE ( startDate_, 4 )

VAR Act =
CALCULATE ( SUM ( Sales[Kilos] ), Sales[Invoice date] >= startDate_ && Sales[Invoice date] <= endDate_ ) / 1000

RETURN Act

Best regards
Lotte

[amitchandak]

@LotteLaugesen , I am assuming this measure and data type is number/decimal

If there no issue try return like

return

sumx(summarize(Table, Table[number], Table[Start Date],"_1"), [Act])

[LotteLaugesen]

Yes, it is decimal number 🙂

I'm not sure that I understand your solution.

I need both values for Actual per Number and the total for Actual.

[amitchandak]

@LotteLaugesen ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[LotteLaugesen]

Hi
I have added a new file where the calculation is visible 😉
https://1drv.ms/u/s!AoecG91dlcEedQ5858sIN8ZRh9c?e=0ag264 
Hope you can help me 🙂

Best regards
Lotte

[LotteLaugesen]

Hi

I have added a link to the pbix file.
https://1drv.ms/u/s!AoecG91dlcEedFWCA6Fii_s-q9c 

I hope you can help me 🙂

Best regards

Lotte