RAnge filtration based on column values

[srkase]

Hi all,

My data is 

PROD	TOT	STG	year
A	5	5	20012002
B	10	10	20012002
C	15	15	20012002
D	20	20	20022003
A	5	5	20022003
B	10	10	20022003
C	15	15	20022003
D	20	20	20032004
A	5	25	20032004
B	10	30	20032004
C	15	35	20042005
D	20	40	20042005
I need to define the ranges  and then work out the total qty
Range is to be desired on the stg
Range criterial	Range
>=1 && <=5	1-5
>=6 && <=10	6-10
>=11 && <=15	11-15
>=16	16+
Required Result
year	Range1-5	Range6-10	Range11-15	Range16+
20012002	10	10	15	0
20022003	5	10	35	0
20032004	0	0	0	35
20042005	0	0	0	35

Thanks in advance...

REgards

SRK

[MahyarTF]

Hi,

In my opinion, there are 2 ways :

1- Create a Group by right-clicking on the STG and Choice New Group :

then use the new column (group column) in your visual (Matrix table):

2- Create new column in your table and then use it in Matrix Table visual :

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

TOT measure by range: =
CALCULATE (
    SUM ( Data[TOT] ),
    FILTER (
        Data,
        Data[STG] >= MAX ( 'Range STG'[Min] )
            && Data[STG] <= MAX ( 'Range STG'[Max] )
    )
)