Explore Courses Blog Tutorials Interview Questions
0 votes
in BI by (11.1k points)

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? 

1 Answer

0 votes
by (22.5k points)

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        

Related questions

0 votes
1 answer
0 votes
1 answer
asked Dec 27, 2020 in BI by Chris (11.1k points)
0 votes
1 answer
asked Mar 29, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
asked Jan 11, 2021 in BI by Chris (11.1k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

30.5k questions

32.5k answers


108k users

Browse Categories