cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kfschaefer Member
Member

Summarize rows of data

I am trying to create a matrix that displays the data with a summation of the Transaction Amount for each Category.  My current sum(Transaction amount) displays the same value as the grand total.  What am I doing wrong?

 

Capture.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
kfschaefer Member
Member

Re: Summarize rows of data

thanks however, I was able to resolve the issue via the query.

 

Karen

3 REPLIES 3
Super User
Super User

Re: Summarize rows of data

@kfschaefer do you have transaction account and category in two different table? Can you share your sample data and data model?

 

Here is post whcih describe how to get answer quickly. https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut! Connect with me on Linkedin






kfschaefer Member
Member

Re: Summarize rows of data

thanks however, I was able to resolve the issue via the query.

 

Karen

Super User
Super User

Re: Summarize rows of data

@kfschaefer cool. although you solved wiht query but you could have achieved the same in powerbi. FYI




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut! Connect with me on Linkedin