Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

enumlist calculation from another table

Uk
Silver 1
Silver 1

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

0 2 96
2 REPLIES 2
Top Labels in this Space