How can I enclose If statement inside a calculate?

[Mclovin100]

Hello,

I have a card that I want it to be dynamic. If someone selected a school from the slicer it will choose that schools MonthlyBudget.

If the user dosent select a school it will just sum all the monthlybudget column.

I tried to use this measure.

CALCULATE ( SUM ( SchoolsBudget[MonthlyBudget] ),_T2, IF(HASONEFILTER(Schools[School]), FILTER(SchoolsBudget,SELECTEDVALUE(SchoolsBudget[School]) = SchoolsBudget[School]) , SUM(SchoolsBudget[MonthlyBudget])))

but its giving me this error

A function 'FILTER' has been used in a True/False expression that is used as a table filter expression. This is not allowed.

What can I do to fix this?

[v-easonf-msft · Accepted solution]

Hi, @Mclovin100 

Please try formula like:

Measure1 =
IF (
    ISFILTERED ( Schools[School] ),
    CALCULATE (
        SUM ( SchoolsBudget[MonthlyBudget] ),
        FILTER ( SchoolsBudget, SchoolsBudget[School] IN VALUES ( Schools[School] ) )
    ),
    CALCULATE ( SUM ( SchoolsBudget[MonthlyBudget] ), ALL ( SchoolsBudget ) )
)

If it doesn't work, please share a sample pbix for further research.

Best Regards,
Community Support Team _ Eason