Forum Discussion
Revenue Total
Anonymous
Hi, try changing in the relationship Cross Filter Direction to BOTH
Regards
Victor
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Greg_Deckler This is nice but seems a little complicated for what I'm trying to achieve? I just need my rows to stay put while the grand total of all revenue is at the bottom. There are no measures being calculated:
I then attempt to sum all revenue
So does the first table represent the source data?
Greg_Deckler That is correct.
OK, that's very strange. I don't see that. Since I wasn't going to retype your table by hand (post data in a format that can be copied):
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
But, I created 3 lines like this:
Company IDDelta AccountRevenue
EMS-0100 Woods Rogers PLC $60,739.15 EMS-0181 Carlisle School $33,972.23 EMS-0340 Yale Carolinas, Inc $71,676.6 And I got this:
Not sure what is going wrong on your end, but ?
Hi Anonymous,
Did you create a calculated column from the sum of revenue?
danextian I believe so. In the query editor there were multiple revenue amount for each account so I grouped everything by the company id and summed by the revenue column. I didn't need each individual payment amount for each company, but just what the totals were for each account.
