Forum Discussion
aggregation measure
Hi I have a two tables one is FactSales and one is DimCust. FactSales Customer # Season Units Sold 123 S20 10 123 S20 5 234 S20 15 234 S19 20 ...
Hi v-xicai
Thanx for quick response but it it not what i need. It gives me the max but what i need is to have the sum of all customer per that Account Manager. ... the number in the SalePerAcctMng should be same numbers for the same Account manager .
So I need the Sum of Units sold in S20 to iterate over the Table of Account Managers
Hi Anonymous ,
I am not sure what desired result would you want, could you please share your sample data and desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.
Please read this post to get your answer quickly: How to Get Your Question Answered Quickly.
Best Regards,
Amy