Forum Discussion

StoryofData's avatar
StoryofData
Icon for Helper III rankHelper III
3 years ago
Solved

Count of excluding Values

Hi, trying to do a measure to count Subject IDs when column type DOES NOT equal to "Ask a Question" or "Referral"   = CALCULATE(COUNTROWS('Table'), 'Table'[Subject ID], 'Table'[Type] <> {"Ask ...
Need Help
Tutorial Requests
  • darkinvader_'s avatar
    darkinvader_
    3 years ago

    Hi StoryofData ,
    Could you please try this code :-
    COUNTROWS( FILTER( 'Table', NOT('Table'[Type] IN {"Ask a Question", "Referral"}) && 'Table'[Subject ID] <> BLANK() ) )

darkinvader_'s avatar
darkinvader_
Icon for Resolver I rankResolver I
3 years ago

Hi StoryofData ,
Could you please try this code :-
COUNTROWS( FILTER( 'Table', NOT('Table'[Type] IN {"Ask a Question", "Referral"}) && 'Table'[Subject ID] <> BLANK() ) )

  • StoryofData's avatar
    StoryofData
    Icon for Helper III rankHelper III
    3 years ago

    thank you