Forum Discussion

Stopira's avatar
Stopira
Frequent Visitor
5 years ago

DAX tips to sum amount

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. ðŸ˜†

 
 

 

 

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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