Get the largest value of each Row in Matrix Power BI

[b244293]

Hi,

I have created the table(Dummy) mentioned below,

LeadId	DateName	Quarter
1	Sunday	Q1
2	Sunday	Q1
3	Sunday	Q1
4	Sunday	Q1
5	Sunday	Q2
6	Sunday	Q2
7	Sunday	Q3
8	Monday	Q1
9	Monday	Q1
10	Monday	Q2
11	Monday	Q2
12	Monday	Q2
13	Monday	Q2
14	Monday	Q2
15	Monday	Q3
16	Monday	Q3

Here, My goal is to highlight the biggest value of each row in Matrix view.

So, Could you help me to create the DAX query?

Thanks,

Bala N.

[Greg_Deckler · Accepted solution]

Sure, put DateName in a matrix visual for rows. Put Quarter in the Columns of the matrix. For the Values, put COUNT of LeadID. Create a measure like:

Measure =
VAR __Table =
SUMMARIZE(
ALL('Table'),
[DateName],
[Quarter],
"__Count",COUNTROWS('Table')
)
VAR __Count = COUNTROWS('Table')
RETURN
IF(__Count = MAXX(__Table,[__Count]),1,0)


Then base your conditional formatting off of that Measure.

[dm-p]

Hi @b244293,

I've provided a solution on your other post w/attached workbook.

Regards,

Daniel