Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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...
DAX
VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
5 years ago

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 ✌️!!

Anonymous's avatar
Anonymous
Not applicable
5 years ago

VahidDM 

 

This is giving count of names but i need count of distinct planid for each name like below (Count column is expected)

NamePlanidCount
A12
A22
B11
c12
c22
c22
  • VahidDM's avatar
    VahidDM
    Icon for Super User rankSuper User
    5 years ago

    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✌️!!