Forum Discussion

Richard_Halsall's avatar
Richard_Halsall
Icon for Helper IV rankHelper IV
5 years ago
Solved

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   FactTu...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    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.

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
5 years ago

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.