Forum Discussion

Madhusmita's avatar
Madhusmita
Frequent Visitor
3 years ago

filter out numbers from the calculation

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

 

 

Need Help
Show and Tell

3 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    3 years ago

    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.

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    3 years ago

    hi Madhusmita 

    try like:
    Measure =
    SUMX(
        FILTER(
           TableName,
           NOT TableName[Progress] IN {0, 1}
        ), 
       TableName[Progress] 
    )