Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

sum if filtered

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.

Need Help
  • VahidDM's avatar
    VahidDM
    5 years ago

    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  !!

1 Reply

  • VahidDM's avatar
    VahidDM
    Super User
    5 years ago

    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  !!