DAX formula to find unique values for a case

[KennC]

I have a table in PowerPivot that I am looking to find unique users who have done work on a particular case and enter that number as a numeric value in a colume. For the table 'CaseUsers' below I am looking for a DAX formula that will give me the results listed in the column [Count of Unique Users] which are the unique users in [User] that have done work on each particular case [CaseID].

[TABLE="width: 342"]
<tbody>[TR]
[TD]CaseID[/TD]
[TD]User[/TD]
[TD]Count of Unique users[/TD]
[/TR]
[TR]
[TD]1234567[/TD]
[TD]JD2310[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]1234567[/TD]
[TD]KC5150[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]1234567[/TD]
[TD]JD2310[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]1234567[/TD]
[TD]KC5150[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]1234568[/TD]
[TD]JH5623[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]1234568[/TD]
[TD]DC5642[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]1234568[/TD]
[TD]JV7854[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]1234568[/TD]
[TD]JH5623[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]1234569[/TD]
[TD]KC5150[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]1234569[/TD]
[TD]KC5150[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]1234570[/TD]
[TD]JD2310[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]1234570[/TD]
[TD]KC5150[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]1234570[/TD]
[TD]JH5623[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]1234570[/TD]
[TD]JV7854[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]1234570[/TD]
[TD]KC5150[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]1234570[/TD]
[TD]JH5623[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]1234570[/TD]
[TD]JV7854[/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]

Thank you in advance.

 

[Kazlik]

This should work

=CALCULATE(DISTINCTCOUNT(SheetName[User]),FILTER(SheetName,SheetName[CaseID]=EARLIER(SheetName[CaseID])))

 

[KennC]

Awesome, thank you Kazlik!