enumlist calculation from another table

[Uk]

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

[Suvrutt_Gurjar]

---

@Uk wrote:

. The function below works, but it's not running smoothly

---

You may want to elaborate what you mean by this?

---

@Uk wrote:

This expression could impact performance

---

Here you may wish to update are the two tables having any reference relationship and if so which table refetences which table.

[Uk]

I have a table named 'Jurnal SD' (in form format), and this table references another table, 'Data Siswa'. In the 'Data Siswa' table, I have created virtual columns for 'Alpa', 'Sakit', and 'Izin' to reflect attendance entries from 'Jurnal SD'. The formula is correct, but when I fill out 'Jurnal SD' for 'Alpa', 'Sakit', and 'Izin', the total should automatically be updated in the 'Data Siswa' table under the columns 'Alpa', 'Sakit', and 'Izin'. However, in reality, I need to click edit and save for the attendance count to update in the 'Data Siswa' table.

Is an action or automation required to ensure that the student absence count is automatically recorded in the 'Data Siswa' table?