Forum Discussion

harry6810's avatar
harry6810
Frequent Visitor
2 years ago
Solved

Calculate Measure with IF Statement

Hi, I'd like to create a measure that counts all the occurrences of "1" in a table (column "Status"). This will be used to visualize the data in a chart. Current Measures: - eLen price = CALCULATE...
IFStatement
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    harry6810 , Try using below measure

     

    Count of Ones =
    COUNTROWS(
    FILTER(
    'YourTableName',
    'YourTableName'[Status] = 1
    )
    )

bhanu_gautam's avatar
bhanu_gautam
Super User
2 years ago

harry6810 , Try using below measure

 

Count of Ones =
COUNTROWS(
FILTER(
'YourTableName',
'YourTableName'[Status] = 1
)
)