Forum Discussion
Revenue Total
Anonymous
Hi, try changing in the relationship Cross Filter Direction to BOTH
Regards
Victor
Anonymous - 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
OK, so the firs table does not represent your raw source data.
Greg_Deckler Does that mean I'll be unable to do what I'm attempting to do?
None the wiser I'm afraid, I have just recreated a similar setup and all works fine. Perhaps if you can share the file we can help quicker.
I didn't need to aggregate in Power Query - when I drag the measure / column to the table it automatically aggregates it by company or the attribute that I've selected
Anonymous I wish I could but I cannot hand over company credentials since I'm logged into our CRM system through these datasets. I will keep playing around with it to figure out what's going on. Thank you and Greg_Deckler for you help!