measure to retrieve the selected value in the same Table

[mim]

I want to build a measure that return the selected value in the same viusal for example, if the user select france, then the measure return 30 and ignore the filter context of the dimension country.

probably it is easy, but can't figure out how to escape the filter context, tried disconnectd table without success.

thanks 

[v-eachen-msft]

Hi @mim ,

I don't think it is possible in the same table. When you click on this row, the context has been filtered. You could do it with slicer or in another table.

[mim]

 Thanks, I know it can be done in another table, but in this particular use case, it has to be in the same table, trying to reproduce a Tableau report, all good

[Anonymous]

interesting but does not seem possible!

[amitchandak]

@mim ,

Try like

measure =
var _m1 = sumx(allselected(Table),Table[value])
return
calculate(_m1,all(Table))

or

measure =
var _m1 = sumx(allselected(Table),Table[value])
return
calculate(_m1,removefilters(Table[country]))

[mim]

it does not work, when I click on italy, I expect the measure to return 55 for all rows