It's a virtual column formula that should show the output of an enumlist.
When I select 1 value, it shows the output as intended.
When I select two or more values, the output disappear 😮
I tried different formulas but sometimes it don't even show up no matter if I select one or more values.
The number of rows at the right of the column name does change, so it's a display issue.
I tried :
filter("Dossier EGC",contains([Nom du fichier], [Documents liés]))
Select(Dossier EGC[Nom du fichier],IN([_THISROW].[Documents liés], Dossier EGC[Nom du fichier]))
(Dossier EGC[Nom du fichier] - unique(Dossier EGC[Nom du fichier] - [Documents liés]))
INTERSECT([Documents liés], Dossier EGC[Nom du fichier])
This is how my list is set up :
Solved! Go to Solution.
Thanks for the answer, Marc.
Thanks to your reply, I realised that my formula should ref the key column, which was not the case.
How is the Documents liés column defined? Is it an EnumList-Ref to Dossier EGC? If so, your VC expression is as simple as [Documents liés]
Thanks for the answer, Marc.
Thanks to your reply, I realised that my formula should ref the key column, which was not the case.
User | Count |
---|---|
15 | |
14 | |
8 | |
7 | |
4 |