Forum Discussion

souvik900766's avatar
souvik900766
Helper IV
5 years ago
Solved

Count issue

Hi ! Little Urgent Kindly help ! I am trying to count no of L (Leader) , C (Challenger), E (Explorer)which is an output of a if condition from a measure. By combination of count will be Category...
  • lbendlin's avatar
    lbendlin
    5 years ago

    what's your reasoning for this one?

    Company Name = CALCULATE(FIRSTNONBLANK(MSR[company_nm],1),FILTER(ALL(MSR),'Brand name'[Brnd-nom]=MSR[Brnd-nom]))

    Do company names really have to be calculated at data source refresh?

lbendlin's avatar
lbendlin
Super User
5 years ago

what's your reasoning for this one?

Company Name = CALCULATE(FIRSTNONBLANK(MSR[company_nm],1),FILTER(ALL(MSR),'Brand name'[Brnd-nom]=MSR[Brnd-nom]))

Do company names really have to be calculated at data source refresh?