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.
Regarding relationship, click on "Manage Relationships" button in the home ribbon. Then drag name in table 1 to name in table 2. In table 2, make sure that each row has a name and don't leave them as blank.
If still not working, please send me the PBIX file you are trying to create.