Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
want to work on a dax to get the coun't or values in that perticular colum.
Solved! Go to Solution.
I think it also can work for me thanks will check it even i have worked on it
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.
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.
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?
Hey @Anonymous ,
Your requirement is not very clear. Can you please elaborate?
Also, please provide sample data.
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
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
I think it also can work for me thanks will check it even i have worked on it
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
104 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |