Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Turnover = sum('Main data'[TURNOVER.])
Turnover on client = CALCULATE([Turnover];VALUES('Main data'[Payer id]);all('Main data'[Turnover cohort 8000]))
Turnover cohort 8000 = SWITCH(TRUE();
[Turnover on client]<2000;"0-2000";
AND([Turnover on client]>= 2000;[Turnover on client]<4000);"2000-4000";
AND([Turnover on client]>= 4000;[Turnover on client]<6000);"4000-6000";
AND([Turnover on client]>= 6000;[Turnover on client]<8000);"6000-8000";
[Turnover on client]>= 8000;"8000+")
Turnover on client is correct but I got 2 lines per client with Service Utilities!
How Can I receive correct table where line with Utilities will be in the "4000-6000" cohort?!
Help me, please!
The values of [Transactions] are different.
I don't undestand You...
Data like this:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |