Filter with ALLSELECTED to ALL TABLES / SLICERS

[Red217]

Hi, 

is there a way to do a measure that has a filter with ALLSELECTED from all tabels ? , I have about 25 filters .

example of 1 filter:

CALCULATE(sumx('Table',[measure]),

FILTER(ALLSELECTED('DataBreach Filter Slicer'[Filter_Selection]),'DataBreach Filter Slicer'[Filter_Selection]=[DevDatabreachFilter value]),

I have about 25 filters, is there an easy way to combine them to get the value of measure WITH ALL SELECTED FILTERS? 

[Anonymous · Accepted solution]

// Your measure needs to be built
// in a certain way.

calculate(
    [your measure - its full definition or its plain name here],
    allselected( facttable1 ),
    allselected( facttable2 ),
    ...
)

// As many facttables must be accounted for
// as there are dimensions affected and connected
// to them. Also, only the fact tables count
// which the measure in question depends on.

[Red217]

Thanks EXACTLY what i needed, 

THANK YOU !!!

[Anonymous]

Yes, there is but it also depends on the layout of your model. If you put ALLSELECTED( YourFactTable ) as a directive in CALCULATE(TABLE), it'll combine filters from all dimensions that are connected to your fact table by many-to-one (chain of) relationships.

[Red217]

Thank you,

• How do I "figure out" what is the main selector ( slicer)?, currently when displaying my measure on the visual it literally has about 25 filters.... So where should I start?

Thank you