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

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

Hi Anonymous,

Did it solve your problem?
Did my message help you in any way? If it did, please mark my message as the solution and give it a "kudo", I'll appreciate it and help me out