Forum Discussion
Solved
Count Error
Hello, I need to make a graph showing how many times each person has their name in column "Done by" and "Checked by". The issue is that the graph "Checked By" is correct but the graph for "Done ...
Hi alhashmi ,
Create one active relationship and on inactive relationship.
Use USERELATIONSHIP() function to create a measure for the inactive column.
Measure = CALCULATE(COUNT('Table'[Checked by]),USERELATIONSHIP('Table'[Checked by],Who[person]))Result would be shown as below.
Best Regards,
Jay
Hi alhashmi ,
Create one active relationship and on inactive relationship.
Use USERELATIONSHIP() function to create a measure for the inactive column.
Measure = CALCULATE(COUNT('Table'[Checked by]),USERELATIONSHIP('Table'[Checked by],Who[person]))Result would be shown as below.
Best Regards,
Jay