conditional column's condition is not dynamic

[Julianaz]

Given below:
1. one condition column

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

2. the measure in the condition column

[LTD DUE total for MMYYYY] is a measure calculating the aggregation of beginning to date.

3. a slicer of Date table

Issue： [LTD DUE total for MMYYYY] is returning a dynamic value but within 1 the condition column, the value is just up-to-today's aggregation won't change according to the date slicer.

Looking for a solution.

[Anonymous · Accepted solution]

Hi  @Julianaz ,

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

[chonchar]

You can conditionally format visuals based on certain rules. So, if a value is >=x you can make the callout value green and vice versa. 

Cam