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] )