Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Measure based on 2 conditions

Hi,

Here is my data and I want to calculate the count of "Overdue Clarification"

Answer = 2.

"I want it in a measure"

Need Help
  • negi007's avatar
    negi007
    5 years ago

    Anonymous you can create a measure like below

     

    Measure  = CALCULATE(COUNT('01_Measures'[Column]),'01_Measures'="Overdue Clarification")
     
    this is with one condition you can put multiple conditions as well like below
     
    Measure  = CALCULATE(COUNT('01_Measures'[Column]),'01_Measures'="Overdue Clarification", '02_Measures'="Overdue")

1 Reply

  • negi007's avatar
    negi007
    Community Champion
    5 years ago

    Anonymous you can create a measure like below

     

    Measure  = CALCULATE(COUNT('01_Measures'[Column]),'01_Measures'="Overdue Clarification")
     
    this is with one condition you can put multiple conditions as well like below
     
    Measure  = CALCULATE(COUNT('01_Measures'[Column]),'01_Measures'="Overdue Clarification", '02_Measures'="Overdue")