Forum Discussion
Solved
Create an MTBF Measure that summarises Machine Types by Brand
Hello, I'm quite new to PBI and have been stuck on a task since last week. I'd be so grateful if someone can help me, please....It's driving me crazy! My firewall prevents me from uploading a file...
Hy CMoppet . Just do like that. It should must work. you can check this file for your reference.
MTBFbyBrand =DIVIDE(SUM(BaseSummary[OperationalWeeks]),SUM(BaseSummary[ALL Repairs]))
Greg_Deckler Appreciate you helping 🙂
I've done the above but it gives me a blank table as soon as I add the new measure.:
The Operational Weeks is this measure:
Operational Weeks = SUM(BaseSummary[Grand Total])*sum(BaseSummary[Weeks in Reporting Month])
And TOTAL REPAIRS is this:
TOTAL REPAIRS = 'BaseSummary'[Total Hard Repairs] + 'BaseSummary'[Total Soft Repairs]
which comprises measures for both Hard ans Soft repairs, like this:
Total Hard Repairs =
var _Type = SELECTEDVALUE('BaseSummary'[MonthYearMachineType])
RETURN
COUNTROWS(
FILTER(
'WO Raw Data',
'WO Raw Data'[MonthYearMachineType] = _Type
&&
'WO Raw Data'[HARDSOFT] = "Hard"
&&
'WO Raw Data'[MTBF Repair?] = "Repair"
)
)
I just can't figure out what I'm doing wrong?
Hy CMoppet . Just do like that. It should must work. you can check this file for your reference.
MTBFbyBrand =
DIVIDE(
SUM(BaseSummary[OperationalWeeks]),
SUM(BaseSummary[ALL Repairs])
)