conditional column's condition is not dynamic

Hi  Anonymous ,

Measure is calculated at query time and calculated columns are created before the query and do not change , when refreshing the model, calculated columns are created and stored in the table. The values stored in the rows do not change based on user selections.

Reder to:

Calculated Columns and Measures in DAX - SQLBI

You can create a meausre and place it in the Background color of the specified column.

Test Condition measue = if([LTD DUE total for MMYYYY]<0,"White",if( [LTD DUE total for MMYYYY]>0,"Black",blank()))

Format style: Field value

What field should we base this on  : [Test Condition measue]

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly