The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
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+")
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
The difficulty is that I don't know How can I calculate amount of every user even if field USER_ID doesn't selected.
HI @Ustinovdl,
I'd like to have some sample data to test.
Regards,
Xiaoxin Sheng
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
94 | |
94 | |
86 | |
69 | |
65 |
User | Count |
---|---|
232 | |
128 | |
116 | |
82 | |
82 |