Forum Discussion
Two aggregations on the same table
I got this to work. What i had to do was change the count function into calcuate and add UseRelationship. All good! Thanks for the help!
Solution SageThis sort of thing is easiest if you make a date table to use as your bar graph axis, then make an active relationship to the createdate and an inactive relationship to the shipdate. It's then just a case of two measures - one counting the rows, and another counting the rows using the alternative relationship. Take one from the other, job done
I had tried that but i suspect there is an issue with the way i am counting the rows. I am using COUNT(PickList[Create]) and COUNT(PickList[ShipDate]) however i get the same total for each date in the series.
I created a new, seperate date table and pointed the two dates as you suggested and i an still seeing an aggregate that is the same for all days.
I got this to work. What i had to do was change the count function into calcuate and add UseRelationship. All good! Thanks for the help!