Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
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)

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...