Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I used this measure that returns the count of all rows in a column that contains 10000:
Solved! Go to Solution.
@Anonymous
You can try this formula
CountBuisinessUnit = CALCULATE ( COUNTROWS ( FILTER ( 'All Current Employees', VALUE ( 'All Current Employees'[Business Unit]) = 10000 || VALUE ( 'All Current Employees'[Business Unit]) = 10100)))
Hi@Anonymous,
It's pleasant if your problem has been solved, could you please mark the reply as Answered? that way, other community members will easily find the solution when they get the same issue.
Hope it helps.
Best Regards,
Caitlyn Yan
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous
You can try this formula
CountBuisinessUnit = CALCULATE ( COUNTROWS ( FILTER ( 'All Current Employees', VALUE ( 'All Current Employees'[Business Unit]) = 10000 || VALUE ( 'All Current Employees'[Business Unit]) = 10100)))
Thank you themistoklis!
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
71 |