cancel
Showing results for
Did you mean:
Frequent Visitor

## 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?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III

## Re: problem with calculating retention

@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 )
)```
Try my new Power BI game Cross the River
2 REPLIES 2
Super User III

## Re: problem with calculating retention

@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 )
)```
Try my new Power BI game Cross the River
Highlighted
Frequent Visitor

## Re: problem with calculating retention

That worked amazingly! Thnx a lot

Announcements

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

#### Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

#### Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors