slicer measure -- used in different tabs

perezco — Tue, 26 Jan 2021 22:25:21 GMT

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()
)
)

Re: slicer measure -- used in different tabs

amitchandak — Wed, 27 Jan 2021 02:17:31 GMT

perezco , Based on what I got

do you want two different definitions (formula) for a measure? then it not possible. You can combine the two in one formula. But the measure will remain the same across the report. You can not have measure definitions page wise

topic Re: slicer measure -- used in different tabs in DAX Commands and Tips

slicer measure -- used in different tabs

Re: slicer measure -- used in different tabs