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!!
Catman's avatar
Catman
Frequent Visitor
2 years ago

Thank you so much, it is working as expected now.