Forum Discussion
Distinct count over multiple tables
Hello Experts, I have a situation where I need to calculate UNIQUE NUMBER OF ENGAGED USERS. In my data model people can: sumbit an idea like an idea comment an idea All of these a...
HI Martin-Prague ,
Unfortunate, current dax formula not support auto calculate related table fields.
I'd like to suggest you create a bridge table to link and merge these tables fields and use id to manually summary and calculate on these tables.
Optimizing Many-to-Many Calculations in DAX with SUMMARIZE and Cross Table Filtering
Regards,
Xiaoxin Sheng
Thanks all, at the end I build a view in SQL that combines my data into one table and then I am able to do this calculation simply in Power BI.