Forum Discussion
Filter exclude
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?
Thanks for your explanation, but it's still hard for me to think of a solution without seeing the data and how it relates or without a concrete example of what you have now and the end result you want.
If you can, read this article, which is a good summary of what you need to do to be able to help more effectively.
I will try to explain as much as possible:
I'm building on a new way to visualize costs based on a scenario. Let's say there is a ID that holds to following data:
ID | Provider | Location 1 | Location 2 | Type | cost_amount
The provider is the company arranging the transport and the ID is the contract holding this information. In this contract there are cost types with their price, that may differ based on the container size. Like I said, the cleaning costs can be based on this size, also the transport price can be based on the size. However some costs, like handling, are not effected by the size. When filtering through scenarios, we select the size of the container, the weight, the locations to have the report show the ID/contracts that may arrange the selected transport. Currently when I put lets say type35 in the transport it will exlude the costs that are for all types, because this is labeled as TypeAll. I don't want to always have to select All but I want to have All allways selected. When the user selects type35 it also must show the costs with TypeAll.
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?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