ifstatement
1 TopicCalculate 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)Solved419Views0likes1Comment