Dax filter functions

[StephenCooper]

Hi,

I am trying to calculate expenses as a percent of revenue. Model is simple:

Fact table: actualGLAccountFact
- attribute: [Account Total]
Dim table: dimGLAccount
- attribute: Account Type

Here is my DAX command. I keep getting Infinity.

Opex %Rev:=-CALCULATE(SUM(actualGLAccountFact[Account Total]), dimGLAccount[Account Type] = "Expenses")/CALCULATE(SUM(actualGLAccountFact[Account Total]), FILTER (ALL(dimGLAccount), dimGLAccount[Account Type]="Revenue"))

 

[miguel.escobar]

Stephan,

you think that you could upload a copy of your workbook so we could have a better look at it? I'm not getting the full picture here, sorry =/