Create a var/measure/column containing the selected value of Slicer

[iamprajot]

I want to use the selected value of a Slicer for further purposes.

[v-chuncz-msft]

@iamprajot,

Here are two links for your reference.

• https://www.sqlbi.com/articles/using-the-selectedvalue-function-in-dax/
• https://www.sqlbi.com/articles/the-in-operator-in-dax/

[iamprajot · Accepted solution]

This is what I was looking for, to get the Selection or Selected_Value and to use that value or the value corresponding to that.

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.

[miltenburger]

You have to use the 'drillthrough' function of Power BI,

Here is some information about it: 

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-drillthrough/