Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |