Forum Discussion
619SK
2 years agoHelper II
Power BI Conditional Base filter calculation
Im not able to find the neasur to calculate below condition in measure , i have updated sample Final expected data to be on bi
- 2 years ago
- It's because of the order in which they are listed. 66 is greater than 30 so a match is found and no further rules will be evaluated for that value. They should be evaluated in descending order.
= if [Age_c] ="0-15" and [Count] >=50 then 90 else if [Age_c] = "0-15" and [Count] >= 30 then 95 else 100
jennratten
2 years agoSuper User
619SK Please review the solution posted and click Accept as Solution if it answered your question. Thanks!