Next Level display

Hi NimaiAhluwalia,
Thank you for reaching out to the Microsoft fabric community forum. Thank you lbendlin, for your inputs on this issue.

After thoroughly reviewing the details you provided, I was able to reproduce the scenario, and it worked on my end. I have used it as sample data on my end and successfully implemented it.

Create NextLevelMeasure in the FactTable:

NextLevelMeasure =

VAR SelectedLevel = SELECTEDVALUE('FactTable'[Level])  -- Get selected level

VAR NextLevels =

    FILTER(

        'MappingTable',

        'MappingTable'[Parent Level] = SelectedLevel  -- Find next levels for the selected level

    )

VAR NextLevelNames = VALUES('MappingTable'[Next Level])  -- Get the names of next levels

RETURN

    CALCULATE(

        SUM('FactTable'[Amount]),

        'FactTable'[Level] IN NextLevelNames  -- Filter fact table to next levels

    )

I am also including .pbix file for your better understanding, please have a look into it:

I hope this could resolve your issue, if you need any further assistance, feel free to reach out. If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.