Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.