leaf Level View

[Anil2264]

Hi Team,

Please help me out to find a logic by using I can get the "output data table" on the basis of the "current view table". I wanted to have only Leaf level to be populated in the report for each FG it should not populate the rest levels, only leaf level to be populated.

@amitchandak  @dax 

Current View
FG	L1	L2	L3	L4
A
A	123
A	123	876
B
B	222	567
B	222	567	678
B	222	567	678	987

Output
FG	L1	L2	L3	L4
A	123	876
B	222	567	678	987

[Daryl-Lynch-Bzy]

HI @Anil2264  - are you looking to implement the PATH dax functions?  Please consider the following from SQLBI:

PATH – DAX Guide

There is a short video explaining how to use PATH functions.

However, if your table is really this simple, using GROUP BY max value would work.

Many thanks
Daryl

[Anil2264]

Hi @Daryl-Lynch-Bzy 

The current table view is showing after using parent-child heirarchy . I need only leaf level to be populat in report as per output view given.

[v-janeyg-msft · Accepted solution]

Hi, @Anil2264 

According to your description, I have a simple method. You need to ceate a index column in power query, then create a measure and put it in visual filter pane to filter row.

Like this:

Measure =
VAR flag =
    MAXX (
        FILTER ( ALL ( 'Table' ), [FG] = SELECTEDVALUE ( 'Table'[FG] ) ),
        [Index]
    )
RETURN
    IF ( SELECTEDVALUE ( 'Table'[Index] ) = flag, 1, 0 )

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,

Community Support Team _Janey