topic DAX tips to sum amount in DAX Commands and Tips

DAX tips to sum amount

Stopira — Thu, 12 Nov 2020 09:03:42 GMT

Dear Experts,

I have data table looks like this:

I want to create a report that end up like this:

Please give me some DAX tips to do it. 😆

Re: DAX tips to sum amount

amitchandak — Thu, 12 Nov 2020 10:19:11 GMT

Stopira , I think max for item number, Min for column 1 and sum for column 2. Rest all are un summarized

Re: DAX tips to sum amount

Anonymous — Fri, 13 Nov 2020 05:13:43 GMT

Stopira Hey Mate,
First create a measure Amount = sum('table name'[amount])
then select a table then simply drag your all these dimension and in value feild put measure we just created .
you will get output like this

Re: DAX tips to sum amount

wdx223_Daniel — Fri, 13 Nov 2020 07:39:13 GMT

Stopira this may be the trick