Forum Discussion
Help with SUMX (VALUES...
Hi I'm hoping for some help with my measures. My data is quite sensitive so it's not easy to share. I've attempted to rewrite as sales so hope it makes sense I have written a measure to count...
Hi Miguel
Thanks for your reply. I did try to create some dummy data from my file but struggled because even the fields have sensitive names so it was messing up all of my measures!
I can see that when it comes to my SUMX measure it is summing for all outcome IDS, not just those specified in the variables in the first measure. I did experiment with adding a field to the SUMX measure but this then stops the totals in my matrix working correctly.
What I really need to understand is how to only sum the values in the outcomes table for the variables defined in the initial measure.
Any advice would be great - thank you!