Decomposition Tree last node Value is not displaying

Hi Sumnima39 ,

Thank you for reaching out to the Microsoft Community Forum.

If you are using a column (Trade) from the fact table that already has a relationship with your measures but you have used a disconnected table for the “Explain By” path, the aggregation might break at the final node. This causes the node to show the category label but not aggregate the measure because of a context mismatch.

If the final node is categorical and no actual value is being evaluated within that node's filter context, you get a blank or missing value. This is common when the measure doesn’t respond well to the column context introduced by the last node.

Please try below things to fix the issue

1. If possible, avoid using a column from the disconnected table as the final node. Instead, use the Trade column from the same table the measure is derived from.

2. If possible, Modify Measure with ISINSCOPE or HASONEVALUE DAX function

Example :

Trade Measure =

IF (
ISINSCOPE('FactTable'[Trade]),
[BaseMeasure],
BLANK()
)

Or  if you are using a disconnected table (TradeDim):

Trade Measure =

VAR SelectedTrade = SELECTEDVALUE('TradeDim'[Trade])
RETURN
CALCULATE(
[BaseMeasure],
FILTER('FactTable', 'FactTable'[Trade] = SelectedTrade)
)

Note: This will give your measure the row context at the final node level. Make sure your Decomposition Tree's “Analyze” field uses only numeric measures, not columns. Only the "Explain By" pane should contain columns. If you are using dynamic measures, ensure the measure logic is correctly switching depending on the selection in the disconnected slicer.

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh

Regards,

Dinesh

Hi Sumnima39 ,

If your issue is resolved.  Please do let us know , if you have any further queries.

Regards,

Dinesh