Forum Discussion
Native Matrix Visual Glitch - Expand/Collapse buttons not working
- 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
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