Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Get total in row using matrix

Hi all,   I have data as below     I want to have the table as below using matrix table with total breakdown is combined as sum.  But what I get when place column category,ani...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Guys, 

     

    I have found the answer. I made another table which group by the total breakeven by anmial;

     

    BREAKEVEN_TABLE = SUMMARIZE(animal_table, animal_table[animal], sum(animal_table[breakeven])).

    BREAKEVEN_TABLE connect to animal_table using animal as key.


    Thank you!

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , I doubt you can get like first screenshot. But you can get 10 the same number first screenshot

 

You can have a new column

sumc(filter(Table, [Category] = earlier([Category]) && [animal] = earlier([animal]) ), Table[breakeven USD])