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!!
shafiz_p Hello 🙂 I have replcated your work and the result is now correct in the example of choosing a single brand; ABC. However, if I test it again slicing by type and/or age, it doesn't seem to work for me. For example, if you select Machine Type 'ABC Element', August 2023 should be circa 51.6 (4450 machines * 4.43 weeks, all divided by 382 repairs), and if you then also select the Age Bracket '1Yr1d - 5Yrs' the result for August should be circa 74.7.
Please can you help me spot how to correct this?
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 🙂