Grouping Descriptors and metrics in a visual if less than 10

[DebbieE]

Apologies I added this before but the answers got confusing and didnt help me solve the issue so i thought i would try again with more detail

So I have the following

Fact   TotalPeaple (Measure)

Dim Person

And I have a table that drags in PersonGroup from the Dim and TotalPeople from the measure

PersonGroup    TotalPeople

A                       100

B                        50

C                       20

D                       9

E                        7

F                        2

For D E and F I need the descriptor to say 'Aggregated under 10'

And the total to come to 18

PersonGroup                                 TotalPeople

A                                                   100

B                                                     50

C                                                     20

Aggregated under 10'                     18

So far I havent found a way of doing this. Nothing has worked. I suspect its two measures but i just cannot figure out if this one is doable. 

Anyone with  any ideas on this?

[amitchandak]

@DebbieE , Assuming TotalPeople is measure

Then you have create a table like

Bucket = addcolumns(generateseries(1,200, 1), "Bucket", if([Value]>= 10, [Value]&"", "Bucket under 10") )

Then you have to use the segmentation logic in another measure

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

[DebbieE]

Thanks for that. I think its too complex for what I need and may slow things down a lot but I might be able to use the first part. i dont like having to create the extra table.

I wish Power BI had something more intuitive and easy to use. feels like it needs adding as an idea

Microsoft Idea

I have added this into ideas. Seems like im being asked for this more and more and something easier to use in Power BI would be super helpful without the need for complex DAX or extra tables