Forum Discussion
Show N value based on measure difference
Hi everyone.
10 Replies
- amitchandak
Super User
claudia-amm , Not very clear but try except , if that can help
except(all(Table[Creator]),all(Table[user]))
- claudia-amm
Helper I
amitchandak I've already tried but it didn't match on my request below. Thanks anyway!
- mahoneypat
Microsoft Employee
Please generate some mock data that shows same issue and share that, to help suggest a specific expression.
Regards,
Pat
- claudia-amm
Helper I
mahoneypat thanks for your explanation!! now, i'm wondering if i don't want to show all the 7 differences and could only show 3 values? how can i do that?
Thanks
- mahoneypat
Microsoft Employee
It's just the reverse, but with the Creator column in the table visual.
Creators Not Users =
COUNTROWS (
EXCEPT (
VALUES ( 'List Creator'[Kreator] ),
VALUES ( 'List User'[Name] )
)
)Regards,
Pat
- claudia-amm
Helper I
mahoneypat sorry i think my question isn't clear enough. what i meant by showing only 3 values is from this table:
I tried to do it in reverse but the table gave me a different value which is this
This an example for the expected result:
Koroh CCC Periyadi CCC Runtuwene CCC Thanks
- mahoneypat
Microsoft Employee
What is different about those three names to use in the logic to return just them?
Regards,
Pat
- claudia-amm
Helper I
Could we add a new Index Column or random number to both table as a differentiator?