Power BI DAX: ALLSELECTED with exception of one column

Question

How can I select all feilds of dimensions expect for 'Dimension[Feild 4]' and Ihave implemented as below

[My Measure] := CALCULATE(SUM(Fact[Quantity]), ALLSELECTED('Dimension'[Field 1], 'Dimension'[Field 2], 'Dimension'[Field 3]))

But it is not long term solution I need equation something like this

ALLSELECTED('Dimension, EXCEPT('Dimension'[Field 4])) 

How can I solve this? 

Answer 1

Use the following measure

[My Measure] :=
CALCULATE(SUM(Fact[Quantity]), ALLSELECTED('Dimension'), VALUES('Dimension'[Field 4]))

Want to learn more about Power BI? Check out today: Power BI course