Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Ustinovdl
Helper I
Helper I

How come?!

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+")

 

Безымянный.jpg

 

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!

3 REPLIES 3
v-chuncz-msft
Community Support
Community Support

@Ustinovdl,

 

The values of [Transactions] are different.

http://community.powerbi.com/t5/Desktop/Count-Function-Issue-When-Adding-Additional-Column/m-p/33722...

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I don't undestand You...

Ustinovdl
Helper I
Helper I

Data like this:

2.jpg

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.