Field hierarchy detection

[yanivshe86]

Hi all,

I have a problem modeling\viewing my data in PBI.

I have a table of product tree (3 level hierarchy):

TOP_LEVEL	MID_LEVEL	LOW_LEVEL
A	A_1	A_1_1
A	A_1	A_1_2
A		A_1_3
B	B_1
B	B_2	B_2_1
B	B_2	B_2_2

And for each product level I have its sales score in a different measure.

So for example:

B score is 0.78

B_2 score is 0.83

B_2_1 score is 0.89

The score for each level is calculated in 3 different measures (one for each product level:

- score_top_level_measure

- score_mid_level_measure

- score_low_level_measure

I want to use a tree visual to show the score of each product.

So I added TOP_LEVEL, MID_LEVEL & LOW_LEVEL to the categories, but my problem is with the "value" field.

When I will click on TOP_LEVEL product and view the MID_LEVEL I want to see the scores of the MID_LEVEL products.

How can I know which product level the tree is showing?

How can I achieve what I want?

Note: Some levels don't have MID_LEVEL\LOW_LEVEL produts to them

[lbendlin]

For ragged hierarchies like yours you generally use ISINSCOPE() to suppress the output for deadend branches.

I hope the third line in your sample data is a typo?