Forum Discussion
Sum on Max value
Hi there, I have a measure (I created Commulative total in SQL table) Gross Billing_C = Calculate( max(BillingStatus[INV_AMT_C]) - max(BillingStatus[IMEMO_AR_AMT_C]), Filter(JobComplete,Job...
Refer this :https://community.powerbi.com/t5/Desktop/SUM-of-AVERAGE/td-p/197013
If it does not help.
Can you share sample data and sample output. If possible please share a sample pbix file after removing sensitive information.Thanks.
My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
amitchandak
Super User
Super UserRefer this :https://community.powerbi.com/t5/Desktop/SUM-of-AVERAGE/td-p/197013
If it does not help.
Can you share sample data and sample output. If possible please share a sample pbix file after removing sensitive information.Thanks.
My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970