Forum Discussion
jimmyswoosh
Advocate I
Advocate IAlternative Approaches To Referencing Calculated Measure in a Calculated Column?
Hi Power BI Community! Goal: To be able to identify outlier values from the dataset dynamically and have them highlighted in the table. Approach: I have created a calculated measure 'MTTCA_...
I was able to accomplish what I needed by creating a measure for each metric value and a measure for each metric's outlier threshold.
Then I created a measure, using switch to compare the metric value to the threshold and return either "Outlier" if it's above the threshold or "Not Outlier" if it's below or equal to the threshold.
jimmyswooshAdvocate I
Advocate IThanks v-lili6-msft for the reply,
For clarification on my part, are you saying that there's no way to acheive a workaround solution since we can't compare measure in a column?
-James
v-lili6-msft
Community Support
Community Supporthi, jimmyswoosh
the result of measure is dynamic and the result of column is static, so they can't be compared in together.
It is usually that column and column comparisons or measure and measure comparisons.
Best Regards,
Lin