Forum Discussion
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...
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.
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