Forum Discussion

qmartiny's avatar
qmartiny
Icon for Helper III rankHelper III
4 years ago

Calculating overlap between calculated columns

Hello lovely people,   Given this table [Account] with calculated columns [SPx].   Account Account SP1 SP2 SP3 AAA 1 1   BBB   1 1 CCC 1     I have created a slicer c...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

your first two variables get you a scalar value, not a column. You can still do an intersect but it will only test if these scalar values match.

 

If you cannot hard code the column names then you need to use measures. But you mentioned that these are calculated columns in the first place.  Maybe explain the setup in more detail.

qmartiny's avatar
qmartiny
Icon for Helper III rankHelper III
4 years ago

Hm. I am stuck since my slicer doesnt have the same name as my column header anyway..

 

I'll try using a UNION table to unpivot the data see if that's easier.

 

Thanks