Count Distinct Values Pivot Table

[nburaq]

Hi,
I would like to count distinct values based on the combination of multiple columns.(In sample Location+Item+Status) I added my table as data model to count distinct values but it does not give correct results. I know how to distinct count using helper column or excel function like =IF(COUNTIFS($C$2:C2,C2,$B$2:B2,B2)>1,0,1)but is there any way to do it in power pivot ? as calculated column or measure? Thanks for comments and help

Location	Item	Status	Distinct Count
Kitchen	Plates	Moved	1​
Kitchen	Spoons	Stayed	1​
Saloon	TV	Moved	1​
Saloon	Chair	Moved	2​
Saloon	Chair	Moved	2​
Bathroom	Mirror	Stayed	1​

 

[denzo36]

For multiple columns, the best way to do it is concatenate those columns into one column (maybe separated by a dash or a colon) and then take a distinct count of that column by adding to the data model and using distinct count under value field settings