Forum Discussion
Conditional measure used as visual level filter does not work properly
Hi Umesh_DataViz,
The behavior you’re observing occurs because the measure is being calculated in two different contexts. In the table visual, the measure is evaluated row by row using the dimensions in each row. However, when you use the same measure in the Visual level filter, it’s calculated at a higher-level context, which can lead to different results. That’s why it appears correct in the table but changes when used as a filter.
To ensure consistent results, consider using a calculated column instead of a measure. Calculated columns are evaluated once at refresh and remain fixed for each row, so they work reliably in Visual level filters. If you need dynamic logic, you can create smaller helper measures that return TRUE/FALSE values for each section and use those to filter, which helps maintain a consistent filter context and avoids unexpected recalculations.
Thankyou.
Hi Umesh_DataViz,
The behavior you’re observing occurs because the measure is being calculated in two different contexts. In the table visual, the measure is evaluated row by row using the dimensions in each row. However, when you use the same measure in the Visual level filter, it’s calculated at a higher-level context, which can lead to different results. That’s why it appears correct in the table but changes when used as a filter.
To ensure consistent results, consider using a calculated column instead of a measure. Calculated columns are evaluated once at refresh and remain fixed for each row, so they work reliably in Visual level filters. If you need dynamic logic, you can create smaller helper measures that return TRUE/FALSE values for each section and use those to filter, which helps maintain a consistent filter context and avoids unexpected recalculations.
Thankyou.
Thanks v-sgandrathi for your solutions. This helped me to fis the issue. Appreciate It.
