cancel
Showing results for
Did you mean:
Regular Visitor

## Calculate clients by cohorts on client's turnover

How can I divide clients on different cohorts by its turnover?

I want create some cohorts like

0-100

100-200

200-500

500+

and then count clients on each of them like

0-100 - 100 clients

100-200 - 350 clients

200-500 - 20 clients

500+ - 10 clients

if I choose any filter like Source (out site, biller site etc) I want to recalculate previous table like

Our site:

0-100 - 70 clients

100-200 - 300 clients

200-500 - 12 clients

500+ - 10 clients

Biller site:

0-100 - 30 clients

100-200 - 50 clients

200-500 - 8 clients

500+ - 0 clients

Can I do it in Power BI Desctop?

4 REPLIES 4
Regular Visitor

## Re: Calculate clients by cohorts on client's turnover

My thoughts:

Measure

Turnover by client = CALCULATE(SUM(Clients[TURNOVER.]);FILTER(Clients;VALUES(Clients[USER_ID])))

Column

Turnover cohort = SWITCH(TRUE();
Clients[Turnover by client]<100;"0-100";
AND(Clients[Turnover by client]>= 100;Clients[Turnover by client]<200);
"100-200";Clients[Turnover by client]>=200;"200+")

Super User

## Re: Calculate clients by cohorts on client's turnover

Also you can use the technique of PARAMETER tables to get the ranges/cohorts.

May be this post is similar to your requirment

http://community.powerbi.com/t5/Desktop/Company-Durations/m-p/365291/highlight/true#M165168

Try my new Power BI game Cross the River
Regular Visitor

## Re: Calculate clients by cohorts on client's turnover

The difficulty is that I don't know How can I calculate amount of every user even if field USER_ID doesn't selected.

Community Support Team

## Re: Calculate clients by cohorts on client's turnover

HI @Ustinovdl,

I'd like to have some sample data to test.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

Announcements