Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Unable to find the count of tsg id with respect to the tsg owner
"Total procedure completed" column should calculate how m
Solved! Go to Solution.
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.
@sshiny Try this Measure:
MEASURE = CALCULATE(COUNT(Table[Tag ID]),ALLEXCEPT(TableName,Table[Tag Owner]))
@NickolajJessen I am trying to find the count of tags with respect to the unique tag owner.
My DATA-
I need a third column that gives the value of the count of tags for tag owner "A" and the value of the count of tags for tag owner "B"
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.
Hi,
Make sure to share data in a table format for easy entry in Power Bi for anyone who is try to help
Can you share an illustration of you expected result?
Also include what you've tried to far (measure)
Refer to this thread on how to make a detailed post for a quick soloution 😊
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/2547186#M9020...
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
76 | |
74 | |
55 | |
45 |
User | Count |
---|---|
117 | |
106 | |
77 | |
66 | |
65 |