Forum Discussion
Count by plan
Hi Team, I am having table with two fileds : Name Planid A 1 A 2 B 1 c 1 c 2 c 3 Need to calculate count in measure like below screen shot Name Planid...
This is giving count of names but i need count of distinct planid for each name like below (Count column is expected)
| Name | Planid | Count |
| A | 1 | 2 |
| A | 2 | 2 |
| B | 1 | 1 |
| c | 1 | 2 |
| c | 2 | 2 |
| c | 2 | 2 |
VahidDM
Super User
Super UserHi Anonymous
Try this measure:
Count =
CALCULATE ( DISTINCTCOUNT( 'Table'[Planid] ), ALLEXCEPT( 'Table','Table'[Name]))
Output:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos✌️!!