Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Fixed Charge Coverage Ratio (FCCR)

Hello all.

I need assistance with this ratio measure in PowerBI.

Here is the breakdown of my measures from top to bottom:

FCCR =
CALCULATE(
([Rolling12MonthAdjustedEBITDA] - [Rolling 12 Month Cash Taxes] - [Rolling 12 Month Capital Expenditures]) / [Rolling 12 Month Interest Expense]
)

Rolling12MonthAdjustedEBITDA=

CALCULATE [Adjusted EBITDA], DATESBETWEEN (DateTable[Date],

NEXTDAY (SAMEPERIODLASTYEAR ( LASTDATE (DateTable[Date]))),

LASTDATE (DateTable[Date])

Rolling 12 Month Cash Taxes=

CALCULATE [Total Cash Taxes], DATESBETWEEN (DateTable[Date],

NEXTDAY (SAMEPERIODLASTYEAR ( LASTDATE (DateTable[Date]))),

LASTDATE (DateTable[Date])

Rolling 12 Month Capital Expenditures=

CALCULATE [Total Capital Expenditures], DATESBETWEEN (DateTable[Date],

NEXTDAY (SAMEPERIODLASTYEAR ( LASTDATE (DateTable[Date]))),

LASTDATE (DateTable[Date])

Rolling12MonthIntrest =

CALCULATE [Total CapitalExpenditures], DATESBETWEEN (DateTable[Date],

NEXTDAY (SAMEPERIODLASTYEAR ( LASTDATE (DateTable[Date]))),

LASTDATE (DateTable[Date])

Any assistance will be much appreciated!

1 ACCEPTED SOLUTION
Frequent Visitor

I managed to figure out what the problem was. The issue was the source data and not the measures. Thank you.

4 REPLIES 4
Frequent Visitor

I managed to figure out what the problem was. The issue was the source data and not the measures. Thank you.

Super User

@garzajnc24 - I'm going to work on the assumption your problem is with the first 3 months of 2018 showing "Infinity". This is likely to do with your source data.

But also, assuming all your other calculations are correct (we have no base data to test). Instead of your FCCR measure I would use the below, it's more optimal, and it handles divide by 0 errors.

``````DIVIDE(
([Rolling12MonthAdjustedEBITDA] - [Rolling 12 Month Cash Taxes] - [Rolling 12 Month Capital Expenditures]), [Rolling 12 Month Interest Expense], 0
)``````

Perhaps if this doesnt fix your issue, you can provide some detail over what is wrong, and some sample data.

Super User

@garzajnc24 - I've also noticed your rolling 12 month measures are missing some brackets at the end, but I'm sure you're aware of that. They should be in the format below (note I have changed the date table to match my test model):

``````CALCULATE (
[Total Sales],
DATESBETWEEN (
'Date'[Date],
NEXTDAY ( SAMEPERIODLASTYEAR ( LASTDATE ( 'Date'[Date] ) ) ),
LASTDATE ( 'Date'[Date] )
)
)``````

Frequent Visitor

Thank you, @mark_endicott I will try these suggestion and provide sample source data, if that does not work. My issue is numbers are not reconciling with excel report up to rolling 12 month totals.

## Helpful resources

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Join our Community Sticker Challenge

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

#### Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors