cannot apply a slicer to a measure that uses calculate() with a filter

[Theodore88]

Hi

I am wondering if anyone can help.

I managed to create a measure that calculates the total contracts exposure using DAX formula calculate with a filter.

Even though the formula works there is no way to apply addtional filters to the measure either with a slicer or in the visual panel.(the filter parameter seems to overwrite other filters)

The below is the function I am using if needed, is there any work around to this?

Exposure = calculate(
sum(
Components[NetLJ]
)
,FILTER(ALL (Components),Components[DateLJ]<=max(Components[DateLJ]))

)

[v-sihou-msft · Accepted solution]

@Theodore88

In your forumla, since you apply ALL() function in your filters, it will remove all filters. That's the reason your additional filter/slicer doesn't work. Please replace your ALL() function with ALLSELECTED(). See my sample below:

Exposure = CALCULATE(SUM(Table7[Value]),FILTER(ALLSELECTED(Table7),Table7[Seller]="Seller1"))