Forum Discussion
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
- amitchandakSuper User
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]) )