Using the Selected Value of a Slicer

[iamprajot]

To get the Selection or Selected_Value and to use that value or the value corresponding to that for different purposes.

Create a Measure, Selected = IF(HASONEVALUE(Table[Column A]),VALUES(Table[Column B]),COUNTROWS(Table))

Where Slicer contains Column A values and I can use the selected slicer value or the value corrosponding to it for diffferent calculated columns.

[v-ljerr-msft · Accepted solution]

Hi @iamprajot,

---

Where Slicer contains Column A values and I can use the selected slicer value or the value corrosponding to it for diffferent calculated columns.

---

Not like measures, calculate columns/tables are computed during database processing(e.g. data refresh) and then stored in the model, they do not response to user selections on the report.

So it is not possible to create a calculate column/table can change dynamically with user selections on the report. 

Regards