Help with cohort % also in totals

[NatiArtlist]

Hi guys

trying to build cohort analysis, here based on USD

I created a measure of % from first perios (1), works well except of totals, it takes the entire first column instate of if data is availabe. the correct calculation need toexclude when data is not availavle in next period as follow:

The measue i wrote for the % calculation is:

Retain % = divide(sum('Cohort Table-Annual'[CumulativeCollection]),CALCULATE(sum('Cohort Table-Annual'[CumulativeCollection]),ALLSELECTED('Cohort Table-Annual'[Cohort Month]) , 'Cohort Table-Annual'[Cohort Month] =1))

Thanks 

[Anonymous]

Hi @NatiArtlist ,

Whether your problem has been resolved? If yes, please mark your post as Answered? It will help the others find the solution easily if they face the same problem with you. Otherwise, you can create another measure to replace the measure [Retain %] and put it on the matrix:

Measure = SUMX ( GROUPBY ( 'Table'[Year], 'Table'[Month] ), [Retain %] )

If the above one can't help you get the correct result, you can refer the method in the following links to resolve it.

Why Your Total Is Incorrect In Power BI - The Key DAX Concept To Understand

Dax for Power BI: Fixing Incorrect Measure Totals

Best Regards