Forum Discussion

Sdhn420's avatar
Sdhn420
Helper IV
5 years ago

Filter array of negative values

Hello everyone

How can I allow users to display negative values in an array. I want the user to be able to filter ATP as negative/positive.

I have a matrix like below -

Material ? Stocks ? ATP (Medida)

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Sdhn420 ,

    create an independent table with values negative and positive and try like

    measure =
    if(selectedvalue(sign[sign]) ="positive" , sumx(filter(summarize(Table,Table[Material] ,Table[Stock],"_1" [ATP]),[_1]>=0),[_1])
    , sumx(filter(summarize(Table,Table[Material] ,Table[Stock],"_1" [ATP]),[_1]<0),[_1]))

    • Sdhn420's avatar
      Sdhn420
      Helper IV
      5 years ago

      amitchandak the problem is that the ATP measure is created from two different tables. (Stock and Order).

      The matrix is formed from 3 table values.

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    Hi Sdhn420 ,

     

    Do you mind sharing your .pbix file? 

    Or show us sample data.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.