Forum Discussion
kfschaefer
Helper IV
Helper IVSummarize 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?
thanks however, I was able to resolve the issue via the query.
Karen
3 Replies
- parry2k
Super User
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
kfschaeferthanks however, I was able to resolve the issue via the query.
Karen
- parry2k
kfschaefer cool. although you solved wiht query but you could have achieved the same in powerbi. FYI
