Overwrite FILTER in DAX measure

0
votes

I have a measure defined in a cube like

Sales = CALCULATE(SUM(FactSales[Amount]), FactSales[External] = TRUE())

In PowerBI I would like to override the filter on the External column. I've tried 

All Sales = CALCULATE([Sales], ALL(FactSales[External]))

But ALL(<column>) only seems to work for context filters.

Is there a way to override the DAX filters as defined on the measure in the cube? using DAX.

1
ssasdaxssas-tabular
What's wrong with All Sales = SUM(FactSales[Amount])? – Marco Vos
@MarcoVos I simplified the example, on the Sales measure in the cube there are multiple filters and its only some i wan't to override in the PowerBI. Then i might aswell duplicate the measure in PowerBI minus the 1 filter i want removed. – CodeMonkey

1 Answers

0
votes

My understanding is that you've applied the filter within the [Sales] measure already, so when you define the ALL function, it will only apply to external conext as you've said.

Try this?

All Sales = CALCULATE(SUM(FactSales[Amount]), ALL(FactSales[External]))