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

 

 

IFStatement

1 Reply

  • 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
    )
    )