Giving values to filtered column

ALRUYOYO

1.You need to create a static table for the band. Name the table as Band.

2. The columns should be Position, BandDescription, MinValue, MaxValue

3. The rows could be something thing like

     1, < 7500, 0, 7500

     2, 7501 - 20000, 7501,20000

     3, 20001 - 30000, 20001, 30000

and so on depending on the band that you want to go upto

4. Create a column in the fact table defined as

    GroupPosition = CALCULATE (
                                 VALUES ( Band[Position] ),
                                     FILTER (
                                               Band,
                                            FactTable[Value] >= Band[MinValue]
                                                && FactTable[Value] <= Band[MaxValue]
                                                    )
                                             )

 5. Add this to the table that you are displaying.

Try this out.

If you find this working please acccept it as a solution and also give Kudos.

Cheers

CheenuSing