Forum Discussion
conditional column's condition is not dynamic
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.
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
2 Replies
- chonchar
Helper V
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
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
