Forum Discussion

PedroMorbey's avatar
PedroMorbey
Frequent Visitor
2 years ago
Solved

Native Matrix Visual Glitch - Expand/Collapse buttons not working

Hello,   I currently have a DAX measure that's triggering quite the weird behaviour on the native Matrix visual. I'm using 4 fields which belong to the same table (Dim_Product) on the Rows and tha...
  • PedroMorbey's avatar
    2 years ago

    Anonymous ,

     

    Indeed, after trying to simplify/alter it to see some changes, I was able to arrive at the normal Matrix visual behaviour. I changed the intermediate virtual tables FILTER calculation from a nested IF to a regular boolean evaluation and it worked!

     

    I went from this initial approach where the FILTER condition of the intermediate tables had some nested IFs:

    // Filter tables
        VAR _Filter_HighHigh =
            FILTER(    
                _Final_Table,
                IF(
                    "High x High" IN VALUES(AUX_9Box_Cluster_Performance_Slicer[Performance Cluster]),
                    IF( _Threshold_Type = "Absolute",
                        _Net_Sales_Absolute_High_Threshold < [@Net Sales] && _Gross_Margin_High_Threshold < [@Gross Margin],
                        [@CumulatedPct] < _Net_Sales_Relative_High_Threshold  && _Gross_Margin_High_Threshold < [@Gross Margin]
                        ),
                    False
                    )
                )

     

    To this simpler one:

     

    // Filter tables
        VAR _Filter_HighHigh_Abs =
            FILTER(    
                _Final_Table,
                "High x High" IN _Selected_9Box_Clusters
                && _Threshold_Is_Absolute
                && _Net_Sales_Absolute_High_Threshold < [@Net Sales] && _Gross_Margin_High_Threshold < [@Gross Margin]
                )

     

     

    This measure is far from being optimized, but for now it is working as intended without any major performance issues. Thank you for getting back to me.

     

    Best regards