Forum Discussion

EduardD's avatar
EduardD
Icon for Advocate III rankAdvocate III
4 months ago
Solved

Visual Calculations - no drill through, cannot be used with field parameters for measures?

I have a scenario where visual calcaultions in matrix to work the best BUT It seems I cannot combine Field parameters for measures with Visaul calcaultions based on those measure and hide a field paa...
Need Help
  • Murtaza_Ghafoor's avatar
    Murtaza_Ghafoor
    4 months ago

    EduardD 

    Yes you are right. If you use field parameters + hide columns then apply visual calculation, it is always problematic, on the other hand Drill Through is not supoorted in Visual Calcualtion.


    If this helps, āœ“ Mark as Kudos | Mark as Solution| Help Others

Bipin-Lala's avatar
Bipin-Lala
Icon for Solution Sage rankSolution Sage
4 months ago

Hi EduardD,

 

Field Parameters

Visual Calculations live only within the visual's internal cache, they cannot dynamically re-bind themselves when a Field Parameter swaps the underlying measure.

 

Instead of using Field Parameters for the measures, you can use a Calculation Group.

 

Drill Through

Drill Through works by passing a Filter Context from one page to another.

When you try to drill through, Power BI looks for a column in the database to filter by. Since the visual calculation isn't in the database, the link is broken.

 

If Drill Through is a requirement, you have to move that logic out of the visual and into a DAX Measure.

 

Let me know if it helps!