How the write the expression

[kunkumnaveen]

Hello All,

I had atttached the image ,Please find the attachment 

I need to Color the cell with max percentage of  each model,

For example from multiple model values i had selected CRETA, For Creta i need to color cell with 31% percentage 

Expression for %:

sum({<Year={2018}>}[Volume])/sum({<Year={2018}>}total<[Model]>[Volume])

Thanks

[StarinieriG]

Hi,

try with something like this: 

If(Rank(total sum({<Year={2018}>}[Volume])/sum({<Year={2018}>}total<[Model]>[Volume]))<=Count(total distinct Model & Year),COLOR)

[sunny_talwar]

You can try a color expression like this

If(Max(TOTAL <Model> Aggr(Sum({<Year = {2018}>} [Volume]), Price, Model, Liters, Fuel, Transmission)) = Sum({<Year = {2018}>} [Volume]), LightRed())

Here if you create this expression.... you should see the Max value of the Model repeating for each of the row...

Max(TOTAL <Model> Aggr(Sum({<Year = {2018}>} [Volume]), Price, Model, Liters, Fuel, Transmission))

I did not use the denominator in the expression because it is redundant and will have the same value for all the Model.

[Brett_Bleess]

Naveen, did either of the posts help you with your issue?  If so, please be sure to circle back and give them credit by using the Accept as Solution button on any posts that were helpful in getting the solution you needed.  If you still need further help with things, leave an update of where things stand for us.

Regards,
Brett