Forum Discussion
Revenue Total
Anonymous
Hi, try changing in the relationship Cross Filter Direction to BOTH
Regards
Victor
OK, and with the measure / aggretion set to 'Don't Summarize' and the Totals turned on in the table format, it doesn't do it correctly?
As Greg says, very odd! Apologies I can't be of more help, works fine for me in various different scenarios.
Matt
Community ChampionAnonymous - I think I caught something in his reply that he might be trying to do the sum in Power Query? If that is the case, yeah, he is going to get some weird things happening.
Greg_DecklerCould well be - I've just tried aggregating in Power Query but still working ok, I can't seem to reproduce the error. One thing I've noticed though is that I never have the Don't Summarize option active - doesn't that only appear for text entries?
Perhaps there's a format issue something in the model...
Anonymous Greg_Deckler Here are screenshots step by step of what I did. Maybe one of you can see where I'm going wrong:
And for how my revenue column is modeled:Which gives me this when using 'Don't Summarize'
The moment I change it to 'Sum' on that column
- Greg_Deckler
OK, so the firs table does not represent your raw source data.
Greg_Deckler Anonymous I don't know if it helps or even matters ( I don't think it should) but the Revenue column isn't in the same dataset as everything else. I have 2 objects that are connected through a unique ID. So the dataset I'm using for the Revenue consists of nothing but a unique ID and the revenue amount associated with that ID. I then created a relationship between the two tables based on the Unique ID's. I'm going to try to delete the relationship and just merge the queries instead on that ID to see if it behaves any differently.