sum if filtered

[Anonymous]

hello ,

I did a dashboard with filters.

I want to do a measure that sum the cost only when the first filter is filtered.

I want that when someone first open the dashboard - the total bom cost will be 0 and then when you choose to filter the "system" the cost will changed.

I tried to open new measure but itsn't working and i dont know why.

the measure :

SUMIF = CALCULATE(SUM('TOTAL COSTS'[PRODUCT BOM COST]),ISFILTERED('TOTAL COSTS'[System])=TRUE())

thank you for helping 🙂

Reut Arie.

[VahidDM · Accepted solution]

@Anonymous  
Please try this code:

SUMIF =
IF (
    ISFILTERED ( 'TOTAL COSTS'[System] ),
    SUM ( 'TOTAL COSTS'[PRODUCT BOM COST] ),
    0
)

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos  !!