Calculate Measure with IF Statement

[harry6810]

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(Min('CEN'[Price]),CEN[Reseller]="eLen ")
- Min price = MIN(CEN[Price])
- Status = IF([eLen price] = [Min price],1,0)

[bhanu_gautam · Accepted solution]

@harry6810 , Try using below measure

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