Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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!
@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]))
it does not work, when I click on italy, I expect the measure to return 55 for all rows
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |