Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
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 |
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✌️!!
Hi @Anonymous ,
Try this measure:
Count= CALCULATE(COUNT(Table[Name]), ALL(Table[Planid]))
Thanks
User | Count |
---|---|
41 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |