Table with the three columns and one selectionPosition(INDEX).
the table is called '_Measure Selector Version'.
SelectedPosition || Metric || Numerator || Denominator
1 csat% csat_num csat_deno
2 dsat% dsat_num dsat_deno
3 slo slo_num slo_deno
...
Is it possible to recycle the Measure table used in one tab in a different Tab?
My problem, it is that the second tab maintain some lineage even after the syncronization has been eliminated.
I tried in the second tab, create a clean slicer but this one maintain some connection with the first one from the first tab.
The motive is that I already used that table Measure to be used in a tab with a series of different chart.
Now, I am looking to use the same table Measure in different tab for a series different charts in second tab.
The first tab, I have two dax calculations and the slicer called Metric:
(The slicer control the selection of whatever mesuasure I selected.)
SelectedIndex.Cmpr = Min('_Measure Selector Version'[SelectedPosition])
Formula(M.Cmpr) =
IF(
HASONEVALUE('_Measure Selector Version'[Metric]),
Switch(
[SelectedIndex.Cmpr],
1,[CSAT%] *100,
2,[DSAT%] *100,
3,[SLO]*100,
4,[SL],
5,[TTC (Days)],
6,[Backlog%]*100,
7,[Hours Per Case],
8,[AHT (Minutes)],
9,[DPI],
10,[Throughput],
11,[RDR%]*100,
12,[FTB%]*100,
13,[SL Volume],
14,[Cases Completed],
15,[Utilization],
16,[IB Util %]*100,
BLANK()
)
)
Then, the second tab, I use the same Measure table.
I tried with two new dax calculation that refer the same table, and new slicer not syncronize with the data from the first tab.
SelectedIndex.Outlier = Min('_Measure Selector Version'[SelectedPosition])
Formula(M.outlier) =
IF(
HASONEVALUE('_Measure Selector Version'[Metric]),
Switch(
[SelectedIndex.Outlier],
1,[CSAT%] *100,
2,[DSAT%] *100,
3,[SLO]*100,
4,[SL],
5,[TTC (Days)],
6,[Backlog%]*100,
7,[Hours Per Case],
8,[AHT (Minutes)],
9,[DPI],
10,[Throughput],
11,[RDR%]*100,
12,[FTB%]*100,
13,[SL Volume],
14,[Cases Completed],
15,[Utilization],
16,[IB Util %]*100,
BLANK()
)
)
