Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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.
Hi Liang,
I've been struggling with a measure like this for hours and your post solved my problem.
Thank you very much!
Jason
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.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |