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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Richard_Halsall
Helper IV
Helper IV

Dynamic Grouping based on Sum of Value

Hi

I have viewed many posts but am struggling with a simple grouping function.

 

In this sample data I have 4 tables, DimClient, DimCountry, FactTurbine and a disconnected banding table

 

FactTurbine is linked to DimCustomer on ClientID and DimCountry on CountryID

 

I have created a simple measure which sums total turbines from the FactTurbine table  and using a country slicer can create the dynamic visualisation below:

 

Richard_Halsall_0-1628610511080.png

 

I now need to create a piechart visualisation that sums the number of clients based on the total turbines measure based on a max and min value in the disconnected banded table.

 

So if the bands in the disconnected banded table were

201-500

101-200

1-100

 

Based on the above visual of 15 clients, the calculated count of clients would be:

201-500 = 5

101-200 = 9

1-100 = 1

 

Any help would be appreciated

1 ACCEPTED SOLUTION
V-lianl-msft
Community Support
Community Support

Hi @Richard_Halsall ,

 

Based on the disconnected table you created, create a measure to dynamically distinguish whether the sum of the current client is in this range, and count the clients.

Vlianlmsft_0-1628748882926.pngVlianlmsft_1-1628748898373.png

 

I created a sample pbix for your reference:

 


Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
JasonShanks
Frequent Visitor

Hi Liang,

I've been struggling with a measure like this for hours and your post solved my problem.

Thank you very much!

Jason

V-lianl-msft
Community Support
Community Support

Hi @Richard_Halsall ,

 

Based on the disconnected table you created, create a measure to dynamically distinguish whether the sum of the current client is in this range, and count the clients.

Vlianlmsft_0-1628748882926.pngVlianlmsft_1-1628748898373.png

 

I created a sample pbix for your reference:

 


Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.