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 | Count |
| A | 1 | 2 |
| A | 2 | 2 |
| B | 1 | 1 |
| c | 1 | 3 |
| c | 2 | 3 |
| c | 3 | 3 |
4 Replies
- Tanushree_Kapse
Impactful Individual
Hi Anonymous ,
Try this measure:
Count= CALCULATE(COUNT(Table[Name]), ALL(Table[Planid]))
Thanks
- VahidDM
Super User
Hi Anonymous
Try this measure:
Count = CALCULATE ( COUNT ( 'Table'[Name] ), ALL ( 'Table'[Planid] ) )If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos ✌️!!
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
Hi 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✌️!!
