Need help on calculating sum of the calculated measure.

[Anonymous]

Hi, if there is a power bi pro, please help me.

I'm trying to get the sum of the calculated measure that only shows 1 or 0.

Year	Customer	Total Unit	Retention
2015	10622	0	0
2016	10622	1	1
2017	10622	1	1
2018	10622	1	1
Total		3	1

This is what my table in the Power bi shows. I want to get another measure or retention to be calculate the sum of the retention for each customer. For example, the total row retention column should show 3 instead of 3. Can someone help me on this problem?

[v-eachen-msft]

Hi @Anonymous ,

You could use the following measure.

Measure =
CALCULATE (
    MAX ( 'Table'[Total Unit] ),
    FILTER ( 'Table', 'Table'[Year] = MAX ( 'Table'[Year] ) )
)

Here is the result.

[Anonymous]

This is what I have right now. I want a new measure or the measure on the table to show the total with right calculation. Yours shows the total for measure is still 1 I want it to be 3.

[v-eachen-msft]

Hi @Anonymous ,

Does that make sense? If so kindly mark my answer as a solution to close the case. Thanks in advance.

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

You could try the following measure:

Measure = 
CALCULATE (
    SUM(  'Table'[Total Unit] ),
    ALLSELECTED( 'Table'[Total Unit] )
)

[Greg_Deckler]

@Anonymous - Not sure I understand but this looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907