topic Re: Total of a count on the left hand side of matrix in DAX Commands and Tips

Total of a count on the left hand side of matrix

abeirne — Thu, 10 Feb 2022 03:00:10 GMT

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.

Re: Total of a count on the left hand side of matrix

VahidDM — Thu, 10 Feb 2022 03:30:37 GMT

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/

Re: Total of a count on the left hand side of matrix

Anonymous — Thu, 10 Feb 2022 08:20:31 GMT

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

Re: Total of a count on the left hand side of matrix

Anonymous — Mon, 14 Feb 2022 09:21:30 GMT

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