Forum Discussion
Decomposition Tree last node Value is not displaying
Hi
I am using a Decomposition Tree visual and working with several measures. Since I have only measures, I used a disconnected table and mapped all the measures correctly, allowing me to use them in the "Explain By" feature.
For the last node, I am using columns from the same table that the measures are based on. While the data is pulling correctly, I'm not seeing the numerical values displayed under each value in the visual.
How can I display the correct value under each Trade? Any suggestions would be appreciated.
Yes, It resolved.
Thank you
11 Replies
Sumnima39 Sounds like you need to create an additional measure for that last node so that the measure forms the relationship correctly. Hard to be more specific without more information, sample data, sample PBIX, etc.
Yes, I created the measure, but it wasn’t helpful. The measure pulls the data correctly, but when I add it to the node, it doesn’t work as expected.
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
Defining individual measures for each trade appears to be an effective approach for displaying the data accurately. Thank you for your assistance.
Hi Sumnima39 ,
If your issue is resolved. Please do let us know , if you have any further queries.
Regards,
Dinesh
Thank you for your response, Dinesh.
The issue is that when using the measure, the last node does not display the trade value, even though the measure Pursuing_tradecount, Unfulfill_Tradecount, Expected_Tradecount are displaying respective vlaue correctly in the table view. But same measure from decomp tree is not showing the trade vlaue. Only Numeric vlaue with Blank.
How can I display the trade values when selecting "Pursuing"?
For example:
Combo Welder Pipe 631200: 19
Pipefitter 631100: 27.Hi Sumnima39 ,
Please provide sample PBIX file. It will be easy for me to replicate the scenario from my side.
Regards,
Dinesh
Hi Sumnima39 ,
We haven’t heard from you on the last response and was just checking back. Please provide sample PBIX file. It will be easy for me to replicate the scenario from my side.
Thank you.
