Forum Discussion

DarioH's avatar
DarioH
Regular Visitor
2 years ago

Having Issues using Calculate function, seems to be a problem with the PLACEHOLDER

Hi everyone, I am having issues with the function CALCULATE(), the logic seems obvious to me and it looks like it should work, I am not sure what is the problem, if you have any idea please give me a...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

I don't think measures (Contains_MY) can be used that way as a filter. have you tried implementing your measure's logic into a filter function of your calculate measure like so:

Issue by MY_ =
CALCULATE(
    VALUES(Issue_Report[Issue]),
    FILTER(
        ALL(Issue_Report), 
        IF(
            CONTAINSSTRING(
                SELECTEDVALUE(Issue_Report[MY]), 
                SELECTEDVALUE(MODEL_YEAR_SELECTOR[MY_Selector])
            ) = TRUE(), 1, 0
        ) = 1
    )
)

 careful with the all, i'm not quite sure if there's filter context in your issue_report table that you needed.