Forum Discussion
IF three condition.
- Anonymous9 years ago
Hi JazminMarquez,
I am not sure what is your sample data, but you can check if the following steps return your expected result.
1. Create a new table using the following formula.
image = UNION ( ROW ( "state", "Green", "ImgURL", "https://cdn.pixabay.com/photo/2013/07/13/10/27/hand-157251_960_720.png" ), ROW ( "state", "Red", "ImgURL", "http://www.clker.com/cliparts/5/2/5/8/13476359851958638477thumbs-down-icon-red-hi-hi.png" ), ROW ( "state", "yellow", "ImgURL", "http://www.clker.com/cliparts/l/J/Q/d/1/X/yellow-thumbs-up-md.png" ) )
2. Create a new measure using the following formula.LinkedMeasure = SUMX ( VALUES ( 'image '[state] ), IF ( ( [Totalutility%]>= 0 && [Totalutility%] <= 0.84 && VALUES ( 'image '[state] ) ="Green" ) || ( [Totalutility%] >= 0.85 && [Totalutility%] <= 0.99 && VALUES ( 'image '[state] ) = "Red" ) || ( [Totalutility%] >=1 && VALUES ( 'image '[state] ) = "yellow" ), 1 ) )3. Display image in ChicletSlicer. Image will change based on the value of [Totalutility%] Measure.
Reference:
http://sqljason.com/2015/11/custom-indicators-in-power-bi-using.htmlThanks,
Lydia Zhang
Which part doesn't work?
Whats is the [Totalutility %] Measure formula?
Totalutility is a measure... if i only left one condition, Even though it does not work, I think it is not considering the value of the result of measure Totalutility.. bacause if i change the number por example:
IMG = IF([Totalutility %]>=1,"https://cdn.pixabay.com/photo/2013/07/13/10/27/hand-157251_960_720.png","http://www.clker.com/cliparts/5/2/5/8/13476359851958638477thumbs-down-icon-red-hi-hi.png"),
This example only shows green always, if change the value ">=1" for "<=1" shows a green image..
- Phil_Seamark9 years agoMicrosoft Employee
I think your formula will only work if [TotalUtility %] is a column in your table rather than a calcualed measure.
- JazminMarquez9 years agoFrequent Visitor
The problem is that I can not make the formula, as a calculated column because it is the division of the total of 2 different tables :smileysad:
- Phil_Seamark9 years agoMicrosoft Employee
We can overcome that by creating a dynamic table that is based on two other tables.
It's a little more complex but can be done. It would help to see your two tables so we can generate the formula you need.