Forum Discussion
Show Only Matching Values
If(
SELECTEDVALUE(Sales[Invoice Number]) = SELECTEDVALUE(Sales[faktuurnr]) --Change to your tablename
,"Match"
," "
)
Something like that?
I add the measure in the table but no colum is being created as shown. am i doing something wrong?
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?
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?
Could you create a sample pbix file, replicate the scenarios you are facing,share it with us and then myself or SamWiseOwl can investigate further.
