Help with measure to display Total

[Anonymous]

Hi All,

I am trying to calculate the sum of entries for a given month and for a specific range, I am facing issue with displaying the total of the measure, Could you please help me with it?

<15 = CALCULATE(SUM(Sheet1[entry]),FILTER(Sheet1,SUMX(Sheet1,Sheet1[entry])>0 && SUMX(Sheet1,Sheet1[entry])<15))

>15 = CALCULATE(SUMX(Sheet1,Sheet1[entry]),FILTER(Sheet1,SUMX(Sheet1,Sheet1[entry])>15 && SUMX(Sheet1,Sheet1[entry])<25))

[Vera_33 · Accepted solution]

Hi @Anonymous 

<15 = 
VAR T1 = GROUPBY(sheet1,sheet1[ename],sheet1[month],"@SUM",SUMX(CURRENTGROUP(),[entry]))
RETURN
SUMX(FILTER(T1,[@SUM]<15),[@SUM])


>15 = 
VAR T1 = GROUPBY(sheet1,sheet1[ename],sheet1[month],"@SUM",SUMX(CURRENTGROUP(),[entry]))
RETURN
SUMX(FILTER(T1,[@SUM]>15&&[@SUM]<25),[@SUM])

[Anonymous]

Thanks @Vera_33 , that worked:)