Forum Discussion

donbonbon's avatar
donbonbon
Frequent Visitor
8 years ago
Solved

problem with calculating retention

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?

 

 

Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    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 )
    )

2 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    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 )
    )