Create a conditional column in Table based on slicer selection

[mandihu]

I need to create a customized table that enables users to select which dimension(s) they would like to have for the measure(s).

For example, I have a table like below:

Item	Region	Country	Unit Sold
A	e	h	100
A	e	i	200
B	f	j	300

But now, I would like to have the column Region and Country be dynamic according to the selection of the corresponding dimensionSlicer. That is, I have two dimensionSlicers like below:

dimensionSlicerA

ValueA

Region

Country

Show Blank

dimensionSlicerB

ValueB

Region

Country

Show Blank

If the user selects 'Region' in dimensionSlicerA and 'Show Blank' in dimensionSlicerB, the original table will then be:

Item	Region	Show Blank	Unit Sold
A	e		300
B	f		300

[lbendlin]

You cannot create a calculated column or calculated table from a measure.