problem with calculating retention

[donbonbon]

Hi,

so for example I have this table

I want to divide 115 by 1005, 20 by 1005, then 59 by 1215 etc.  So I created a calculated measure, 

distcount of customers 1st month =

VAR CountCustomers =
DISTINCTCOUNT( Table[users] ) RETURN CALCULATE(DISTINCTCOUNT(Table[users]),

FILTER(Table, Table[sale month]=Table[reg month]))

Then I created another calculated measure,

retention = DISTINCTCOUNT(Table[users])/[distcount of customers 1st month]*100

but it wouldnt get me a result I want:

 

Any ideas how to solve that?

[Zubair_Muhammad · Accepted solution]

@donbonbon

Give this a shot

distcount of customers 1st month =
VAR myvalue =
    SELECTEDVALUE ( Table[reg month] )
RETURN
    CALCULATE (
        DISTINCTCOUNT ( Table[users] ),
        FILTER ( ALL ( Table[sale month] ), Table[sale month] = myvalue )
    )

[donbonbon]

That worked amazingly! Thnx a lot