locked
NOT Contain DAX function for column RRS feed

  • Question

  • Hi,

      I have a column col1 in Pivit table that Col1 have following data 

    Col1
    ----
    Open
    Close
    Cancel

    I want to display only Open and Cancel from that col1

    exp: Col1 NOT IN ("Close")

    Can any one help me out on this using DAX function

    Thank You,

    Grace

     

    Thursday, June 13, 2013 6:49 PM

Answers

  •  Hi Grace Bite,

    Firstly, your question is not clear with me. If you only put "Col1" field on row label in pivot table. Actually, it will be show all of items in table. I suppose you have one column with name is "Amount". You can make below measure on this column and put in values area:

    =CALCULATE(
             SUM(Table1[Amount]),
             Table1[Col1]<>"Close",
             VALUES(Table1[Col1])
      )

    This measure will excluse "Close" value in your table.

    Hopefully, this will help you.

    Regards,

    • Marked as answer by Elvis Long Thursday, June 20, 2013 6:23 AM
    Friday, June 14, 2013 10:52 AM