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?

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        i change the faktuurns to an english name called same value. my problem is the measure won't add in the table. any reason why it can't be done?