Dynamic Grouping based on Sum of Value

[Richard_Halsall]

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:

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

[Anonymous]

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 · Accepted solution]

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.

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.