Forum Discussion

CMoppet's avatar
CMoppet
Helper IV
2 years ago
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...
Need Help
CMoppet's avatar
CMoppet
Helper IV
2 years ago

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?
Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

CMoppet OK, so what do your actual data tables look like? There is likely a problem with relationships or something else. I was assuming that what you showed in your image was the actual source data table but I see that is not the case given the DAX you shared. 

 

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.