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 Following on from my post above, here's what I mean....
The value of 42 shown in the bar chart below is the average of the MTBF results 19 and 65 (highlighted.
However, what it should do in this scenario is add up all the August values in 'Sum of Total Active MCs', multiply this by 4.43 (weeks in period) and then divide by the sum of all the numbers in the August Repairs1 column.