Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
mpressey
Creator
Creator

Exclude Entire Dimension Based on Single Value in Another Dimension with Set Analysis

Is there a way using set analysis to exclude the entire Dim 'a' based on the Dim2 value of '1'. This is an simplified example. 

 

1 Solution

Accepted Solutions
Vegar
MVP
MVP

Try this expression

Count({<Dim = e({<Dim2 = {'1'}>}) >}Dim) 

image.png

View solution in original post

2 Replies
Vegar
MVP
MVP

Try this expression

Count({<Dim = e({<Dim2 = {'1'}>}) >}Dim) 

image.png

mpressey
Creator
Creator
Author

Thanks. This of course works in the simplified example and is essentially what I initially started with in my actual application. Finally, I realized that I was applying the exclusion to the wrong dimension. Thanks again for the reply. It helped me stay on the right track.