wildvikeFrequent Visitor2 years agoSolvedMeasure Total For our company's sales reps, we pay a commission based on the number of new accounts and average balance of those new accounts at a client level, not an overall level. Below is what I put together ...Show MoreDataZoe2 years agowildvike You can wriap the measure in a SUMX to get the total to do what you want.SUMX(Values('Table'[Client #]), [Commission (Sign))])
DataZoe2 years agowildvike You can wriap the measure in a SUMX to get the total to do what you want.SUMX(Values('Table'[Client #]), [Commission (Sign))])
DataZoe2 years agowildvike You can wriap the measure in a SUMX to get the total to do what you want.SUMX(Values('Table'[Client #]), [Commission (Sign))])
DataZoeMicrosoft Employee2 years agowildvike You can wriap the measure in a SUMX to get the total to do what you want.SUMX(Values('Table'[Client #]), [Commission (Sign))])
Related content% of total measureTotal of MeasureMeasure Total IncorrectMeasure Total, againAdjust this measure to show totals
