Forum Discussion
Advocate IIMeasure showing different values on different visuals
Hi,
I am trying to create a measure which could be used to show/hide a visual based on selection on a table. I have one visual on the same report that this works on. Let's say the measure is called "mask" and when mask = 1 it should hide the visual. I put the mask variable on a card visual and on a donut chart. When the appropriate selection is on (visual should show) the card visual shows "2" as the mask value but in the donut chart the mask value is "1". This causes the filter to not work correctly. Any ideas what could be the issue?
Hi Petja,
I think they should be related to visual aggregations, measure expression result will change based on the row context. You can take a look at the following link that mentions row and filter context:
Row Context and Filter Context in DAX
Regards,
Xiaoxin Sheng
2 Replies
PetjaManaged to get it working by removing one variable from the legend of the donut chart. Still, I have absolutely no idea how this advanced filtering is supposed to function.
Hi Petja,
I think they should be related to visual aggregations, measure expression result will change based on the row context. You can take a look at the following link that mentions row and filter context:
Row Context and Filter Context in DAX
Regards,
Xiaoxin Sheng