Uncorrelated fields

[wanyunyang]

Hi guys,

I have a model with two tables like:

Date       ----       Date

Type                    Sales 

Table1 has Date and Type, Table2 has Date and Sales, Date are linked together, but there's no correlation between Type and Sales.

But in the layout, if I put Type as a filter and made selections in there, Sales numbers will change, which shouldn't be since they don't have correlations. How can I make Sales not changing with Type? 

[Channa · Accepted solution]

=sum ( {<Type = >} Sales)

[wanyunyang]

Hi Channa,

Thanks for reply! Is there a way to do this from script? I'm only making an example here with Sales, which is a measure. Actually in my model there are dimensions with this issue as well.

[Channa]

yes you need to do this in script editor only

[wanyunyang]

I mean if not Sales (a measure which can use set analysis), suppose two dimensions Document and Type, how should I write the expression?

[Channa]

Same as above
Type=, Document =

[pradosh_thakur]

Hi @wanyunyang 

I think joining two tables based on date is not quite the right way in my opinion. Unless you have no key and you have to do it as @channa suggested use " field = " in the set analysis.

-Pradosh