4 Replies Latest reply on Nov 8, 2013 1:29 PM by Matt Lutton

# Can I greate a set from measures?

It looks like sets can only be created from dimensions, but I want to create something like it from measures.  How can I do that?

In my data, there are particular fields that are filled for some data points (rows) but not for others.  Let's call them A and B.  I'd like to be able to filter for rows that have data in A but not B, in B but not A, and in A and B.  How would I do that?  My ultimate criteria is to count rows that meet particular criteria in A and B, while understanding how many rows have incomplete data.

I've tried plotting a count of A, then filtering on B to exclude null values, but it doesn't seem to be working - it seems to be filtering on whether A has null values or not.

Any and all solutions gratefully accepted.

• ###### 1. Re: Can I greate a set from measures?

See this related thread, as it may help:

You cannot create a set from measures, as far as I know, but you can use a parameter to do this.

• ###### 2. Re: Can I greate a set from measures?

Abigail,

You can re-characterize a measure as a dimension (just drag it from Measures to Dimensions -- or, if you want to keep them as measures, create duplicate fields for A and B and then use those as dimensions).  Then you can create two sets for the null values and then combined set(s) to do the desired analysis.

Regards,

Joshua

• ###### 3. Re: Can I greate a set from measures?

This doesn't make sense to me.  I don't need it to be dynamic as a parameter is. But I think Joshua's answer will work.

• ###### 4. Re: Can I greate a set from measures?

What doesn't make sense?  Parameters are not dynamic.

But yes, in your case, Joshua's solution may be best.  Parameters can leverage very complex calculations.