Filter within a calculate field across 2 different Dimensions

[Shorey]

Hi (first time poster but have used a lot of solutions provided within the pages)

I have a fact table that i need it identify a MoM (Month On Month) change by a certain measure.  Which i can do however i now need to do it on a subset of the fact table.  Only the records that have had a claim (for example the table has 10,000 records of which only 2,000 have a claim).  I need to isolate the calculation to just these records.  For all the measures so far this has been achieved with the filter function.  However I now need to Filter on Date and a text field.  (hope that all makes sense). 

The code that i am trying to use (i think is correct as far as the syntax goes) is:

claimMoM = Var cLMeasy = Calculate( Key_measures[%Easy], all(Dim_datet),Dim_Datet[Month Rank], Dim_ClaimStatus[ClaimSts] in {"Fault","Non-Fault"}

= min('DIM_DateT'[Month Rank])-1)

Return if( cLMeasy = 0, Blank(), Key_measures[%Easy] - cLMeasy)

So this will only do the %Easy measure for only those records that have a Fault or Non-Fault record.  In theory this should work BUT.  I get an error telling me:

"MdxScript(Model) (187, 117) Calculation error in measure 'Key_measures'[ClaimMoM]; DAX comparison operations do not support comparing values of type True/False with values of type Integer"

I think this means having a date filter and an integer filter cannot be in the same calculation.

Does anyone know how i can overcome this issue.

Thanks in Advance!

[johnt75]

I think you've put the claim status check in the wrong place, in the middle of the check for month rank. Try

claimMoM =
VAR cLMeasy =
    CALCULATE (
        Key_measures[%Easy],
        ALL ( Dim_datet ),
        Dim_Datet[Month Rank]
            = MIN ( 'DIM_DateT'[Month Rank] ) - 1,
        Dim_ClaimStatus[ClaimSts] IN { "Fault", "Non-Fault" }
    )
RETURN
    IF ( cLMeasy = 0, BLANK (), Key_measures[%Easy] - cLMeasy )

[Shorey]

Thanks, @johnt75 as I mentioned below to @SpartaBI (you both gave the same reply) the filter needs to be taking in to consideration when creating the previous month's results and comparing it to this month with the same filters.

[SpartaBI]

@Shorey not sure but I copied the code you sent and seems there was a mix in the lines. I just replaced the lines, try this and tell me if you get the error:
claimMoM = 
VAR cLMeasy =
    CALCULATE (
        Key_measures[%Easy],
        ALL ( Dim_datet ),
        Dim_Datet[Month Rank]
            = MIN ( 'DIM_DateT'[Month Rank] ) - 1,
        Dim_ClaimStatus[ClaimSts] IN { "Fault", "Non-Fault" }
    )
RETURN
    IF ( cLMeasy = 0, BLANK (), Key_measures[%Easy] - cLMeasy )

[Shorey]

Thanks for your reply @SpartaBI that is much easier to read (i must get in the habit of laying the code like that).  However I no longer get the error but it is returning the same result i had before i tried to put the fault non-fault filter in - which suggests it isn't filtering on this factor.  I think it needs to be within the one calculation for the min statement.  I moved it up to after the key_measure, but that didn't work either. (no error message just not the correct result).

Thanks for trying though.