cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ustinovdl Regular Visitor
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
Ustinovdl Regular Visitor
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
Super User

Re: Calculate clients by cohorts on client's turnover

Hi @Ustinovdl

 

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
Ustinovdl Regular Visitor
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
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

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)