Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello to all
I don't know if this is possible and i'm not beeing able to do it.
Consider the following table:
Name Value
cell1 10
cell2 15
cell3 0
cell4 20
cell5 5
cell6 8
cell7 7
MeasureA with value 35.
What I would like to do is something like this:
cell1 Value is less that MeasureA, yes.. color it green
cell1 Value + cell2 Value is less that MeasureA, yes color it green
cell1 Value + cell2 Value + cell3 Value is less that MeasureA, yes color it green
cell1 Value + cell2 Value + cell3 Value + cell4 Value is less that MeasureA, no don't color it..
Is this achievable?
Thanks
Solved! Go to Solution.
Hi @Anonymous
You may try to add some measure and then use conditional formatting on the table.
MeasureB = CALCULATE ( SUM ( Table4[Value] ), FILTER ( ALL ( Table4 ), Table4[Name ] <= MAX ( Table4[Name ] ) ) )
MeasureC = IF ( [MeasureB] < [MeasureA], 1 )
Regards,
Cherie
Very Interesting and wonderful information keep sharing this post kindly check
railway information time table |
Hi @Anonymous
You may try to add some measure and then use conditional formatting on the table.
MeasureB = CALCULATE ( SUM ( Table4[Value] ), FILTER ( ALL ( Table4 ), Table4[Name ] <= MAX ( Table4[Name ] ) ) )
MeasureC = IF ( [MeasureB] < [MeasureA], 1 )
Regards,
Cherie
Hello again @v-cherch-msft
In fact what I have is:
ID Order Value
3 3 10
4 6 4
2 7 0
1 9 6
5 10 0
8 11 0
6 15 3
7 16 7
With this measure as you suggest:
MeasureB =
CALCULATE (
SUM ( Table4[Value] );
FILTER ( ALL( Table4 ) ; Table4[Order] <= MAX ( Table4[Order] ) )
)
but if i add the measure to the table I get incorrect values. If I remove ALL it is even worse because it does not add as expected.
Hi @Anonymous
It seems nothing wrong with your measure. You need drag the order column and value column in table visual.
Regards,
Cherie
Hello @v-cherch-msft
The problem, in my case, is that I have the table filter.. and in the example given. order 1 and 2 for example are filtered but also have a Value, so what is dispalyed in the Measure is not 10 but in my case 25..
I think this is due to the ALL part in the filter.
Is this the case?
Thanks
Hi @Anonymous
You may try to use ALLSELECTED Function instead of All function.
Regards,
Cherie
Hello @v-cherch-msft
Thanks for the quick reply.
It is almost working.. 🙂
It gives me a intial value (in my case 15) which in fact should be 0. It might be due to filters I have. I tried whitout the all but the result is the same.
How can I overcome this?
Regards
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |