Forum Discussion
Need help with Line & Clustered Column Chart
Hello, I have some similar stuff I have to do around pricing. To tackle it i use two measures:
CustomerPrice = SUM(DataTable,DataTable[Price])
ComparisonPrice = CALCULATE([CustomerPrice], ALL(DataTable]))
I can then show the customers on the bars and the comparison as a line. You may want to be more nuanced about the comparison line ie you do want to vary regionally or some such. In that case it might be something like:
ComparisonPrice =
CALCULATE([CustomerPrice],FILTER(ALL(Customer),Customer[Region]=SELECTEDVALUE(Customer[Region]))).Hope this points you in the right direction anyway.
Hello, I have some similar stuff I have to do around pricing. To tackle it i use two measures:
CustomerPrice = SUM(DataTable,DataTable[Price])
ComparisonPrice = CALCULATE([CustomerPrice], ALL(DataTable]))
I can then show the customers on the bars and the comparison as a line. You may want to be more nuanced about the comparison line ie you do want to vary regionally or some such. In that case it might be something like:
ComparisonPrice =
Okay, I will give that a shot! Thank you
I've followed up on your tips to use the Calculate function and I can now show an aggregate average that is not affected by a customer slicer as long as I keep that average on a separate visual. However, once I combine the average along with the customer specific data onto the same chart (clustered column and line) then the customer filter affects the aggregate measure. I can't figure out how to get these two pieces of info on the same chart. Any other thoughts?