Showing only Maximum value Row in Total column of Matrix

[melhajj]

Greetings All,

I have the below table for which I have created a Matrix visual in Power BI Desktop. Each row is an hourly reading and the System Total column is the TOTAL value for each record (Total column in Matrix visual) . Is there a way to only show in the Matrix the row with the Max value ?  For e.g. in the below table , I would want to only show row # 9 which has the MAX value in all the totals , thank you in advance

[Anonymous]

Hello @melhajj ,

Create a measure as shown below and add it to the visual level filter.

Measure = RANKX(ALL('Table'),CALCULATE(SUM('Table'[value]),ALLEXCEPT('Table','Table'[date])),,DESC,Dense)

Best regards

Jay

[amitchandak]

@melhajj , Assume, the value you are using in matrix is [measure] and column is [System] and row is [date hour]

try like

Sumx(filter(Values(Table[Date hour]),[measure]= calculate([measure],allexcept(Table,Table[Date hour]))) ,[measure])

[melhajj]

@amitchandak Thank you for your reply. I just want to clarify one thing :

1 - The values in X,Y,Z,A,B columns are from a field coming from the table , they are not measures

2- SYSTEM TOTAL in the figure is actually the TOTAL column that comes inside the Matrix , it is not a measure 

So basically i want my matrix to ONLY show one record i.e. record #9 because it contains the maximum value amongst all the totals, is your approach still valid in this case ?

Regards,