Forum Discussion
Create a Measure to Count Number of Distinct Values That Have the Same Value in Another Column
Hello, I have call data and based on the data I need to know how many seperate units (Column: Responding Unit Numbers) were assigned to each call (Column: Call Number). Yes, the call numbers in m...
Hi ClackamasAshley ,
I used some of your sample data and you can check the results below:
Total = var _t=CALCULATETABLE(VALUES('Table'[Responding Unit Numbers]),ALLEXCEPT('Table','Table'[Call Number]))
RETURN COUNTX(_t,[Responding Unit Numbers])
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.