Forum Discussion

A_a_a's avatar
A_a_a
Helper III
3 years ago
Solved

Matrix table - conditional formating comparing two measures

Hi All,   I have Matrix table with list of places by week.     Values are based on one measure.   Now I would like to highlight the cells that are lower than data ("Data" is measure too)...
  • amitchandak's avatar
    3 years ago

    A_a_a , Based on what I got.

    The data measure should ignore week filter.

     

    it should like

    new data = calculate([Data], removefilters(Table[Week]) )