topic Re: How to calculate/show rowtotal in DAX Commands and Tips

How to calculate/show rowtotal

LotteLaugesen — Thu, 28 Jan 2021 09:45:16 GMT

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 — Thu, 28 Jan 2021 10:46:41 GMT

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 — Thu, 28 Jan 2021 11:10:03 GMT

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 — Thu, 28 Jan 2021 11:24:56 GMT

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

LotteLaugesen — Fri, 29 Jan 2021 07:28:48 GMT

I hope you can help me 🙂

Best regards

Lotte

LotteLaugesen — Mon, 01 Feb 2021 09:18:05 GMT

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