Forum Discussion
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 Coun...
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 ) )
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 )
)
That worked amazingly! Thnx a lot