Hi - I have been testing the new "Visual Calculations" feature for use cases where I need to apply filter conditions on individual measures inside a table. However, it seems to be limited to only fields/columns present in the visual itself and cannot use other fields in the model.
For example, I need to produce a table with the measure [Revenue] and then immediately next to it display [Revenue] filtered for just one department (the unfiltered [Revenue] measure sums revenue from ALL departments). There is no other way to generate this result without creating a second custom measure in the model for [Revenue - Specific Department]; I was hoping to accomplish this with a single measure using visual calculations and applying the filter condition for the one department on the [Revenue] measure as the second column in a visual calculation.
But this does not seem possible because the [Department] field needs to actually be incorporated into the visual for it to be used; this results in a change to the table itself slicing by [Department] which was not the result I need.
Is there any way in visual calculations to use columns not present in the visual? And if not, is that on the roadmap?
