want to get the count or values of the column

[Anonymous]

Hi,
want to work on a dax to get the coun't or values in that perticular colum.

CALCULATE(count('Marckeet License rep1'[AccessID]),not(DISTINCT('Marckeet License rep1'[purchaserEmailId])) in values('Marckeet License rep1'[ userEmailid]))

help me out to correct it.

[Anonymous · Accepted solution]

I think it also can work for me thanks will check it even i have worked on it

Measure 9 = CALCULATE(SELECTEDVALUE('Marckeet License rep1'[purchaserEmailId]),NOT('Marckeet License rep1'[purchaserEmailId])in values('Marckeet License rep1'[userEmailid]))

in this way

[v-yalanwu-msft · Accepted solution]

Hi, @Anonymous ;

Try it.

Measure = CALCULATE(count('Marckeet License rep1'[User ID]),FILTER( 'Marckeet License rep1',NOT([User ID]) in VALUES('Marckeet License rep1'[Empl ID])))

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@v-yalanwu-msft 

How to show values insted of count. I have tried with selected values function but it works for only single value. How to make it work if there are multiple values user ID.

Measure = CALCULATE(selectedvalues('Marckeet License rep1'[User ID]),FILTER( 'Marckeet License rep1',NOT([User ID]) in VALUES('Marckeet License rep1'[Empl ID])))

 can you help me out in this?

[PC2790]

Hey @Anonymous ,

Your requirement is not very clear. Can you please elaborate?

Also, please provide sample data.

[Anonymous]

Empl ID	User ID
68346	68346
45108	45108
5582	5582
4708	4708
45486	45486
57602	57602
38683	38638
90790	90790
38638	38638
67624	67624
45108	45108
90790	90790
116070	116070
114617	114614

Here is some data in which I want to get distinct of user id values which are not in employee id . Can you help me out

[PC2790]

Something like this?

DistinctCountofMissing = 
var _counttotal = DISTINCTCOUNT(UserTable[User ID])
var _countofpresentvalues = CALCULATE(DISTINCTCOUNT(UserTable[User ID]),
TREATAS(SUMMARIZE(UserTable,UserTable[Empl ID]),UserTable[User ID]))
return
_counttotal-_countofpresentvalues

[Anonymous · Accepted solution]

I think it also can work for me thanks will check it even i have worked on it

Measure 9 = CALCULATE(SELECTEDVALUE('Marckeet License rep1'[purchaserEmailId]),NOT('Marckeet License rep1'[purchaserEmailId])in values('Marckeet License rep1'[userEmailid]))

in this way