Forum Discussion

DaxAssistance's avatar
DaxAssistance
Frequent Visitor
3 years ago

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

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,

 

 

1 Reply

  • 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]) )