Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Show Only Matching Values

Hi    Can someone help me on how to create a measure or m-code in showing only values that matched the Invoice Number for the fak column and don't display the rest?   //NT    
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

thanks for the fast assistance. is it possible not to use the filter pane but shows blanks for rows that don't match so i can see the whole sheet?

  • SamWiseOwl's avatar
    SamWiseOwl
    Super User
    2 years ago

     If(

        SELECTEDVALUE(Sales[Invoice Number]) = SELECTEDVALUE(Sales[faktuurnr]) --Change to your tablename

        ,"Match"

        ," "

     )

    Something like that?

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      I add the measure in the table but no colum is being created as shown. am i doing something wrong?

       

       

      • SamWiseOwl's avatar
        SamWiseOwl
        Super User
        2 years ago

        Interesting!

        Do some of the rows in this table have a matching faktuurnr?

        I can't see faktuurnr in your list of fields, if you add that does it work?

        Is it possible that Sales[Invoice Number] on each row of your visual has multiple values in the table?

         

        Try putting the original measure that returns 1 and 0s in, does that work?