Highlight the max value in count column power bi dax

[Ayappan]

Hi Team ,

      i want to highlight the max vlaue in Table visual.I have data as below . 

      I dont have seperate column for Count of injection Category . I used Count of in Table visual.

      I want to find the max value in count of inject category and add  a new column with color and i should use it in conditional formatting.

  Help me to get the max value in red color and others in green in next new column

[eliasayyy]

hello i did a simple dataset

i created a measure Total which is = CALCULATE(SUM('Table'[Total]))

now i added them to a table

next you need to create a measur ethat will identify what is your max and minimum

Max Value = 
VAR _m = MAXX(ALLSELECTED('Table'),[Total Is])
VAR _con = IF(_m=[Total Is],1,0)
RETURN
IF(_con = 1 , "Red","Green")

next, press on your table to format it ,

go to cell ement part of the format and toggle on background color

choose field value and select your measure

end result

if i helped you solve your question , please consider liking and accepting as solution to better help others

[Ayappan]

Hi @eliasayyy 

     Thanks for you replay . I Dont have Total column in my Database . 
I have only 1 Column and i am using the count of the 1st colimn in Table visual .

Example : in you case i have only Month Column . In my database multiple records has jan feb ... so i am using the count of as 2nd column . I am not able to use the count in the formula you gave .

Let me know how to use it .

Aagin Thanks 

[eliasayyy]

Can you share please sample data as well as your measure 

[Ayappan]

@eliasayyy   

Sample Record from Table

Requirements	A
Others	B
Design/Code	C
Training	A
Others	B
Requirements	C
Others	A
Requirements	B
Others	C
Design/Code	A
Design/Code	B
Design/Code	C
Design/Code	A
Design/Code	B
Design/Code	C
Requirements	A
Requirements	B
Requirements	C
Training	A
Others	B

In Power Bi I had used 

Column 1 and Count of Column 1

I did't use any measure

Thanks

[eliasayyy · Accepted solution]

hello @Ayappan 

step 1 

create count measure

Count = COUNTROWS('Table')

step 2 create the max measure

max of = MAXX(ALLSELECTED('Table'[Catgeory]),[Count])

step 3 create the hightlight measure

Highlight = 
VAR cond = 
IF([Count] = [max of],1,0)
RETURN
IF(cond = 1 , "Red","Green")

step 4 press on your table and go to cell elemnt in the format panel

step 5 select the column you want to highlight 

step 6 choose background color

step 7 press fx and select field value

step 8 

use the highlight measure and click done
results

please leave a thumbs up and accept as solution if i helped you answer your question

[Ayappan]

@eliasayyy Thanks a lot .It helped me is this same applies for Matrix Table also ?

[eliasayyy]

Yes the same applies to matrix tables

[Ayappan]

Hi @eliasayyy 

  In matrix i am facing some problem .Same measures i had used. Its not wokring as expected .

1st measure 

M_CountofMetrics = COUNTROWS(metrics)

2nd measure 

M_MAX_TNK_Issue_Detection = MAXX(ALLSELECTED(jirametrics[Area of Issue detection]),[M_CountofMetrics])

3rd measure

M_Highlight__MAX_TNK_Issue =

VAR cond =

IF([M_CountofMetrics] = [M_MAX_TNK_Issue_Detection],1,0)

RETURN

IF(cond = 1 , "LightGray","White")