Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Filter exclude

Hello all,    I'm facing an issue to have my filter correct: Data is shown as following: type 20 25 30 35 40 all   When making a slicer to filter for different types ...
Need Help
Show and Tell
  • _AAndrade's avatar
    _AAndrade
    2 years ago

    Now I think I get your idea.
    I will create a measure like this:
    SUM( Your column cost ) + CALCULATE ( SUM( Your column cost ) , FILTER ( Your table, Your column cost = "TypeAll")
    That way you always have the cost of each type plus the all cost typeAll.
    On the slicer I would hide the typeAll for not duplicate values if the user select TypeAll.

    This is solve your problem?

_AAndrade's avatar
_AAndrade
Resident Rockstar
2 years ago

Please provide more information about your date. What values are in the Type column?
How is your model related?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    The values in the type column are sizenames for containers. There are prices linked to those types, some prices are not only for one type but for all types (all value), for example:
    Cleaning costs | type20 | 100$

    Cleaning costs | type35 | 120$

    Handling costs | typeAll | 30$

     

    In this scenario, the 120$ costs for cleaning only counts for the 35 type. The handling costs are for all types en therefore adds to the 120$. 

     

    In a report I want to arrange a filter section with multiple slicers to explain a situation and have all related costs shown but I don't want the user to always select "All" to have the costs shown. Does this explain enough?