Conditional Formatting a Matrix Table that uses a date table for its columns

[DaxAssistance]

Hello 

I need assistance in getting the max value for each row in my matrix table.

Currently my measure is highlighting each cell on each table. I know this likely due the filtering of the date table, but when add a removefilter/ all selected into my dax, I get the same outcome.

Would somebody know what I need to change in my dax to resolved this ?

I currently use a trans all table that holds mutiple transactions in an month for an account. I also use a dates table and made a relationship to the date field in the trans all table.

I looked for similar posts on this matter but I could'nt find on that applied a dates to table to the matrix.

Any help will be appreciated thanks!!!

Thanks,

[amitchandak]

@DaxAssistance , Assume you alreay have Measure M1

Max value of Row

calculate( Maxx(Summarize(Fact, Date[Year], Date[Month]) , [M1]) , removefilters(Date, Date[Year], Date[Month]) )