Forum Discussion

tuncay's avatar
tuncay
Icon for Helper III rankHelper III
4 years ago
Solved

Count 2 columns with filters

I want to create a DAX measure or a column, which counts the column "Status Forecast" where the text is "in forecast" and the column "Status Assesment" is "assessed". How can I do this? Thank you in advance.

 

 

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    tuncay Measure, try:

     

    Measure = 
  COUNTROWS(
    FILTER(
      'Table',
      [Status Forecast] = "in forecast" && [Status Assessment] = "assessed"
    )
  )

or

  COUNTX(
    FILTER(
      'Table',
      [Status Forecast] = "in forecast" && [Status Assessment] = "assessed"
    ),
    [Status Forecast]
  )

     

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    4 years ago

    tuncay Measure, try:

     

    Measure = 
  COUNTROWS(
    FILTER(
      'Table',
      [Status Forecast] = "in forecast" && [Status Assessment] = "assessed"
    )
  )

or

  COUNTX(
    FILTER(
      'Table',
      [Status Forecast] = "in forecast" && [Status Assessment] = "assessed"
    ),
    [Status Forecast]
  )