Forum Discussion
619SK
Helper II
Helper IIPower 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
- 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
619SKHelper II
Helper IIThanks for query
Suppose my count result is 0-15 =66
my query is = if [Age_c] ="0-15" and [Count] >=30 then 95, if [Age_c] = "0-15" and [Count] =>50 then 90 else 100
Here ideally expected result for 66 count is 90 but i'm getting result of 95 point.
I'm getting first query as result.
jennratten
Super User
Super User- 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