Forum Discussion
Count distinct rows from other table + value
Hi all, I've got a new question. I've got 2 data sources. Source 1: All the names of the employees and their empl. number Source 2: several names of employees and the devices that they have...
Anonymous
In addition to Omega, for the requirement "if they don't have any devices the value must be 0", create measure as
Total Devices = IF(ISBLANK(countA(Devices[Device])),0,countA(Devices[Device]))
See the demo pbix file attched.
Create a relatationg between the two tables using name. Then create a measure:
Total Devices = countA(Devices)