Forum Discussion
SELECTED VALUE in a Custom Column?
Instead of column in y axis, Use measure. I have created this measure according to you calculation, you have mentioned in your replay.
Test =DIVIDE([Operational Weeks in Reporting Month], SUM(BaseSummary[Repairs1]))For 52.6, Check this:
For 51.6, Check the result (For same setting, no relation developed, only Base table used, bring all necessary values in Base table)For Third case, I have manually filtered your table, and done manual calculation, it is not the same as you want. Why is this different?
For, Machine Type = ABC Element, Age Bracket = 1Yr1d-5Yr, Month/Year = Aug 2023, check this:
Tried manual calculation, and not getting your mentioned value which is 74.7 instead I found 63.6 and column chart showing me that value. Check the below image.
Hope this helps!!
Instead of column in y axis, Use measure. I have created this measure according to you calculation, you have mentioned in your replay.
For 52.6, Check this:
For 51.6, Check the result (For same setting, no relation developed, only Base table used, bring all necessary values in Base table)
For Third case, I have manually filtered your table, and done manual calculation, it is not the same as you want. Why is this different?
For, Machine Type = ABC Element, Age Bracket = 1Yr1d-5Yr, Month/Year = Aug 2023, check this:
Tried manual calculation, and not getting your mentioned value which is 74.7 instead I found 63.6 and column chart showing me that value. Check the below image.
Hope this helps!!
Oh my goodness! This works!!! Thank you so, so much. I can't tell you how long I've spent trying to fix this! I'm so grateful 🙂