Total of a count on the left hand side of matrix

[abeirne]

Hi all, I have been asked to move the matrix's total column onto the right hand side of the matrix. I have tried to do this on my own, but cannot find the correct measure. I am counting the number of analyst per day, and that is giving me the number of reports within their queue. It looks like this : (I have hidden the names)

The # of reports is the count of analyst names. I can't figure out how to put the total on the left side, as I am working with a count and not a sum. Is there anything I can do to achieve this? Thank you all. 

[Anonymous · Accepted solution]

Hi @abeirne ,

I have create a simple sample, please have a try.

Then create a calculated table.

column_total =
VAR _summarize =
    SUMMARIZE ( Table2, [Name], "Date", " Total", "Value", SUM ( Table2[Value] ) )
RETURN
    UNION ( Table2, _summarize )

Currently, there is no way to change the column subtotals to left. Please click the Idea link below and vote for this function.

Idea Link: https://ideas.powerbi.com/ideas/idea/?ideaid=fa4c855b-67ce-4970-b4ee-72226772ba79

[MargaritaG]

Hey, 
If you have e.g. table: Date, Analyst Name and # reports = count( Data[Analyst Name])
Then you can create calculated table 
Analyst Total = Summarize ( Data, Data[Analyst Name], "Total",  [# Reports])
Create Relationship based on Analyst Name between two tables
Then add these table columns into matrix Rows, and use Data (original table) columns Date  in columns & measure [# Reports] in values

Then turn off row sub totals 
and  turn off in row headers Stepped Layout

Result 

Let me know if that solves your problem 

[VahidDM]

HI @abeirne 

Check this link:
https://community.powerbi.com/t5/Desktop/Matrix-with-left-hand-totals/m-p/1238695

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/