Change column in visual based on measure value

[eneasgesing]

I have in my report a table called Departments, with the following structure:

DepartmentName	L1	L2	L3	L4
DP/MNG1	DP	MNG1	null	null
DP/MNG1/SUB1	DP	MNG1	SUB1	null
DP/MNG1/SUB2	DP	MNG1	SUB2	null

In the report there a Data Segmentation visual, with L1, L2, L3 and L4. Additionally, I have a measure thats successful calculate the SegmentationLevel (if is a L2 department, it return 2).

In same report I have a Table visual like this, that works:

DepartmentName	Value
DP/MNG1/SUB1	20
DP/MNG1/SUB2	10
...

But I don't want to display full department, because my company have really big org and there is no reason to unfold so much when a higher org is selected. I need to choose the column based on SegmentationLevel measure. Example: If I segment by L1 = DP and L2 = MNG1, the SegmentationLevel measure will be 2 and I would like Column L3 instead of DepartmentName on Table Visual.

I have tried to calculate, but can't get column based on measure value. Any idea on how to achieve this?

[vanessafvg]

can you share what you have done and can you please provide an example of the expected output of the value in the table

[eneasgesing]

Thank you for your support.

I generated an example file where I show data and explain what I'm trying to do:

Sample Report.pbix 

Hope you can help me with it.