Hello there!
In the virtual column, I want to calculate the total number of data entries from an enumlist result in another table. The function below works, but it's not running smoothly, and there's a note: 'This expression could impact performance.'
Count(Select(Journal A[Mail],and
(IN([_ThisRow].[Name],[Mail]),
[As]="Admin")))
How can I optimize this expression to improve performance? May be there is a better formula . Thanks
User | Count |
---|---|
35 | |
9 | |
3 | |
3 | |
2 |