Forum Discussion

PBIfanatic's avatar
PBIfanatic
Icon for Helper V rankHelper V
4 years ago

Count first occurance

Hi, I have a data requirement to count only the first occurance of an event. So if a Sales rep contacts a company, only the first contact is to be counted.   Sales Rep Company Month ABC ...
Need Help
PBIfanatic's avatar
PBIfanatic
Icon for Helper V rankHelper V
4 years ago

Hi,

 

Is there a way this can be solved please?

 

thanks.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi,

     

    Try this,

    Calculate(DistinctCount(Table[Company]), Sales, [#SalesContact] > 0,Removefilters(ales, [#Month] )

  • Kishore_Kadhir's avatar
    Kishore_Kadhir
    Icon for Resolver II rankResolver II
    4 years ago

    Can you post a screenshot with expected result?

     

    Regards,

    Kishore