Forum Discussion

sshiny's avatar
sshiny
Icon for Helper II rankHelper II
4 years ago
Solved

Finding count

Unable to find the count of tsg id with respect to the tsg owner   "Total procedure completed" column should calculate how m
General Comment
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 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 Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.