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.
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.
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
interesting but does not seem possible!
measure = var _m1 = sumx(allselected(Table),Table[value])returncalculate(_m1,all(Table))
measure = var _m1 = sumx(allselected(Table),Table[value])returncalculate(_m1,removefilters(Table[country]))
it does not work, when I click on italy, I expect the measure to return 55 for all rows
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.