cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Budfudder Member
Member

Re: Reverse Contains?

So the specification "VALUES('Product Types'[Type]" in the outer MAXX specifies the context for the inner MAXX as well?

AlexisOlson Member
Member

Re: Reverse Contains?

Yes. It's a nested context. In the inner MAXX, you can access both [Product] and [Type]. Within the outer MAXX, but not in the inner MAXX, you can only access [Type].

Budfudder Member
Member

Re: Reverse Contains?

Okay, I think I'm starting to get it. As an aside, how would you calculate the number of rows that meet the requirements the statement you provide is testing for? I need to give a count (I just found out)...

AlexisOlson Member
Member

Re: Reverse Contains?

For that, you can just reuse the [Visible] measure.

 

If the Products table doesn't have any duplicate products in it, then you can simply write

 

Visible Count = SUMX(Products, [Visible])

Otherwise, you probably want

 

Visible Count = SUMX(DISTINCT(Products[Product]), [Visible])