I want to calculate maximum occurring color in a metrics in power BI

[Gurpreetsingh55]

I have created a matrics in which i have 9 measures and each one has different color coding , i have also calculated their color coding by creating a measure, Now i want to calculate maximum occuring color in that matrics .

colors are Red ,Amber, Green.

[v-yangliu-msft · Accepted solution]

Hi  @Gurpreetsingh55 ,

I created some data:

If you conditionally set the color by a combination of measure and Field value, you can use the following.

Here are the steps you can follow：

1. Enter data – create a table.

2. Create measure.

Count_color =
var _measure1=
COUNTX(
    FILTER(ALL('Table'),
    [Jan-color]=MAX('color_Table'[Color])),[Index])
var _measure2=
COUNTX(
   FILTER(ALL('Table'),
    [Feb-color]=MAX('color_Table'[Color])),[Index])
return
_measure1+_measure2

Max_Color =
var _max=
MAXX(
    ALL('color_Table'),[Count_color])
return
MAXX(
    FILTER(ALL('color_Table'),[Count_color]=_max),[Color])

3. Result:

Best Regards,

Liu Yang

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

[Gurpreetsingh55]

Hi @v-yangliu-msft it is working for me thank you so much for your help.

[PijushRoy]

Hi @Gurpreetsingh55 

Please create a pbix that contains sample data but still reflects your semantic model (tables, relationships, calculated columns, and measures). Upload the pbix to OneDrive, Google Drive, or dropbox and share the link in this thread. If you are using a spreadsheet to create/import the sample data instead of the manual import method, share the spreadsheet as well. 

[Gurpreetsingh55]

Hi @PijushRoy , Sorry i cannot share the PBIX and data i just want to know the logic if it can be done by any means.

Thanks