Forum Discussion

Catman's avatar
Catman
Frequent Visitor
2 years ago
Solved

Count for ContractID

Hi,    I am having trouble counting the number of occurences for an attribute, in this case ContractID & StartDate. Basically I need to count how many distinct Start Date for each ContractID and sh...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

    Hi Catman - Create a New Column as below:

     

    DistinctStartDateCount =
    CALCULATE(
        COUNTROWS(
            DISTINCT('countff'[Start Date])
        ),
        ALLEXCEPT('countff', 'countff'[Contract ID])
    )
     
    output FYR:
     

     

     

    It works, please check

     
    Did I answer your question? Mark my post as a solution! This will help others on the forum!
    Appreciate your Kudos!!
rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
2 years ago

Hi Catman - Create a New Column as below:

 

DistinctStartDateCount =
CALCULATE(
    COUNTROWS(
        DISTINCT('countff'[Start Date])
    ),
    ALLEXCEPT('countff', 'countff'[Contract ID])
)
 
output FYR:
 

 

 

It works, please check

 
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!