Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Total Across Row

Hi all,   I'm trying to get total across rows. I need a column, where each row has a value of summation across rows.   For example, in below screenshot, I need a column with total sales for each ...
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    You can get your total with this measure, but when you add it to matrix it will add it for each Category.  Adding it as a single column is not doable.

     

    Sales LTM All Cat = CALCULATE([sales LTM], ALL(Orders[Category]))
     
    Regards,
    Pat
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hey mahoneypat , Thanks for the solution. It works. Yeah I'm understanding thats it not possible in powerBI just to add measure in column in a matrix. But atleast I got solution of getting the correct total sales value.

 

Let me know if there is a way I can add measure field in column or rows instead of values. Again thats for the help.