Calculate Measure with IF Statement

harry6810 — Thu, 20 Jun 2024 11:58:52 GMT

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)

Re: Calculate Measure with IF Statement

bhanu_gautam — Thu, 20 Jun 2024 13:01:12 GMT

harry6810 , Try using below measure

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