Sorting

[ghumarepratik21]

We have two condition here as mention below, in which we are getting expected output for first one but not for second in same table.
In grid table mentioned in pic. below we have compound_type column, the condition is 
1. for column which do not have compound_type as Tread as per 'KPI' value are are sorting colors, and getting expected output,

2. if we get any of KPI value between [KPI]<3 && [KPI]>0 and compound_type is Tread then all values should be Red, we are not getting this conditions satisfied
you can see in pic 2 we have one Tread value as 2.14 still we are getting Green color, can you please check this 

[v-rzhou-msft]

Hi @ghumarepratik21 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

[v-rzhou-msft]

Hi  @ghumarepratik21 

The color will return when in value_if_false. I think this issue shouble be caused by the logic_test: Thread_count.

Try this measure:

Kpi_Color_Test = 
VAR _OutPut = IF(Max(Table[compourd_type])<>"Thread",
IF([KPI]>0&&[KPI]<3,"Red",
IF([KPI]>3&&[KPI]<4.3,"Yellow"，
IF([KPI]>=4.3,"Lime"))),
IF([KPI]>0&&[KPI]<3,"RED","Green")
)

If this reply still couldn't help you solve your problem, please share a sample with me. I need to know your data model. This will make it easier for me to update the measure.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.