Forum Discussion

mbbozzuto's avatar
mbbozzuto
Icon for Advocate II rankAdvocate II
2 years ago
Solved

Visual calculations only uses fields in the visual?

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 fi...
"Power BI"
'DAX'
Visual Calculations
  • lbendlin's avatar
    lbendlin
    2 years ago
    Is there any way in visual calculations to use columns not present in the visual?  And if not, is that on the roadmap?

     

    No, and no.  That's the whole point of the Visual Calculations, to NOT reach back into the data model. The only data source is the visual's DAX query.

mbbozzuto's avatar
mbbozzuto
Icon for Advocate II rankAdvocate II
2 years ago

Got it, thanks for the feedback.

 

I have been looking for ways to apply filters on individual measures in visuals to modify the output of that  one measure (rather than modifying all the measures in a visual as Power BI's "Apply filter to visual" does).  Basically, a fourth option for filtering (Filter on visual measure) in addition to the existing 3 (Filter on All Pages, Filter on this Page, Filter on this Visual).

 

The alternative is to add the specialized measure back into the source semantic model; or at a minimum, add the measure in the report-only that is while connected to the semantic model.