Forum Discussion
Revenue Total
Anonymous
Hi, try changing in the relationship Cross Filter Direction to BOTH
Regards
Victor
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!
Anonymous
Hi, try changing in the relationship Cross Filter Direction to BOTH
Regards
Victor
