Forum Discussion
Trying to add a filter using calculated column
- 1 year ago
Hi Revati25,
It appears the issue arises because Power BI doesn't support using measures directly in calculated columns, as they function at a row-level context. A potential solution is to create a calculated column for Exclude Utilization using the actual column values instead of the measure.
Additionally, ensure the denominator has no zeros or blanks to prevent further errors. If the logic is only required for visuals, consider using a Measure instead, which is more efficient.
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
Revati25 Review the calculation of the [Exclude Utilization] measure to ensure that there are no divisions by zero. You can add checks to handle cases where the denominator might be zero.
DAX
Exclude Utilization =
IF(
[Denominator] = 0,
BLANK(),
[Numerator] / [Denominator]
)
I tried checking, there are no zeros encountered