Forum Discussion

619SK's avatar
619SK
Helper II
2 years ago
Solved

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  
  • jennratten's avatar
    jennratten
    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