filter out numbers from the calculation

[Madhusmita]

Hi Team,

I need your help on a calculation. I have a progress column which has numbers in it. I want to exclude 0 and 1 from the calculation.

Can anyone suggest what would be calculation for this?

Thanks

[FreemanZ]

hi @Madhusmita 

try like:

Measure =

SUMX(

    FILTER(

       TableName,

       NOT TableName[Progress] IN {0, 1}

    ), 

   TableName[Progress] 

)

[Ashish_Mathur]

Hi,

If there are no negative numbers in that column, then try this measure

Measure = calculate(sum(Data[value]),Data[Value]>1)

Hope this helps.

[amitchandak]

@Madhusmita , try a measure like

calculate(Sum(Table[Value]), filter(Table, not Table[Value] in {0,1}))