Solved: error message Dax expression

22LACMT · ‎08-23-2023

Hello,

Can someone help with why this is not working? Goal: Cur & Pre are using the key indicator to create a yes or no flag

I am then using the return portion of the dax to give me the count of all the loans on the cur report and not on the prev report.

Anonymous · ‎08-25-2023

Hi @22LACMT ,

According to your screenshot, I think "cur" amd "pre" part are both measures which need to return results in a table. So you need to filter in a table to use these conditions. The syntax should be FILTER(Table, Filter Expression).

Jeopardynewsinceprior =
VAR cur =
    IF ( ImmediateJeopardy[Measure_fpnjeo], "Y", "N" )
VAR pre =
    IF ( ImmJPastMonth1[Measure_Jeopastfpn], "Y", "N" )
RETURN
    CALCULATE (
        COUNT ( MTData[FPN] ),
        FILTER ( ALLEXCEPT ( MTData, MTData[Data] ), cur = "Y" && pre = "N" )
    )

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Anonymous · ‎08-25-2023

Hi @22LACMT ,

According to your screenshot, I think "cur" amd "pre" part are both measures which need to return results in a table. So you need to filter in a table to use these conditions. The syntax should be FILTER(Table, Filter Expression).

Jeopardynewsinceprior =
VAR cur =
    IF ( ImmediateJeopardy[Measure_fpnjeo], "Y", "N" )
VAR pre =
    IF ( ImmJPastMonth1[Measure_Jeopastfpn], "Y", "N" )
RETURN
    CALCULATE (
        COUNT ( MTData[FPN] ),
        FILTER ( ALLEXCEPT ( MTData, MTData[Data] ), cur = "Y" && pre = "N" )
    )

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.