Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Opposite formula for Does not Containrows

Hi Experts

 

i have the following formula 

HAQCount = CALCULATE(COUNTROWS(Case_Data),CONTAINSROW({0,1,11,12,13,14,26,28,34,36,39,43,48,49,50,52,53,54,56,57,58,62,63,69,70,71,72,73,74,75,76,77,78,79,82,84,88,89,94,121,131,132,141,144,146,147,183,186,189,204,206},Case_Data[HMLCaseTypeID]))

 

I do i convert or edit the current  formula to not count the above criteria...include etc...the above.....but everything else...

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago
    HAQCount = CALCULATE(COUNTROWS(Case_Data),NOT(CONTAINSROW({0,1,11,12,13,14,26,28,34,36,39,43,48,49,50,52,53,54,56,57,58,62,63,69,70,71,72,73,74,75,76,77,78,79,82,84,88,89,94,121,131,132,141,144,146,147,183,186,189,204,206},Case_Data[HMLCaseTypeID])))

    ?

     

     

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    8 years ago
    HAQCount = CALCULATE(COUNTROWS(Case_Data),NOT(CONTAINSROW({0,1,11,12,13,14,26,28,34,36,39,43,48,49,50,52,53,54,56,57,58,62,63,69,70,71,72,73,74,75,76,77,78,79,82,84,88,89,94,121,131,132,141,144,146,147,183,186,189,204,206},Case_Data[HMLCaseTypeID])))

    ?