Forum Discussion
sshiny
Helper II
4 years agoFinding count
Unable to find the count of tsg id with respect to the tsg owner "Total procedure completed" column should calculate how m
- Anonymous4 years ago
Hi sshiny ,
I suggest you to create a calculated column by code as below.
Count of tags with respect to the unique tag owner = VAR _Tag_Owner_List = CALCULATETABLE ( VALUES ( 'Table'[TAG_OWNER] ), ALLEXCEPT ( 'Table', 'Table'[Tag Id] ) ) VAR _COUNT_OF_LIST = COUNTAX ( _Tag_Owner_List, [TAG_OWNER] ) RETURN IF ( _COUNT_OF_LIST = 1, 1, BLANK () )Result is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.