Correct total of a Measure

[ianboothman84]

Good Afternoon All 

I am looking to create a measure to add my columns together, but am struggling 😞

i have created a measure to calcualte agent bonus, as you can see from below this is in a matrix table seperated by a Week commecing date. (therefore te one measure)

I would like to add a 'Total' column at the end adding up the values. Can this be done? 

[v-luwang-msft]

Hi @ianboothman84 ,

I think it need to create a new measure and use if (hasonevalue,A,sumx(table,beforemeasure).

Could you pls share your  pbix file ,need to test it .

Best Regards

Lucien

[ianboothman84]

Hello 

I hope i have done this righ 🙂

https://ufile.io/fyqu18u8

[lbendlin]

Please provide sample data in usable format (not as a picture - maybe insert into a table?) and show the expected outcome.

[lbendlin]

You have probably used SELECTEDVALUE() in your measure.  That's not a thing in the totals. Rewrite your measure.

[ianboothman84]

Hi @lbendlin , thank you for your reply. my measure is a simple on 

CA Bonus = CALCULATE(SUM('U&R'[CompassAcceptedFormatted])*[Conversion Bonus])

[lbendlin]

In the settings of your matrix visual enable Column subtotals

[ianboothman84]

hello @lbendlin 

i did this but the values were not correct 

[richbenmintz · Accepted solution]

Hi @ianboothman84 ,

The following should work for you, reference your base measure inside a SUMX

CA BONUS SUMX = SUMX(KEEPFILTERS(VALUES('U&R'[Week Num])), [CA Bonus])

[ianboothman84]

thank you @richbenmintz @v-luwang-msft @lbendlin