Forum Discussion

Anil2264's avatar
Anil2264
Icon for Helper I rankHelper I
4 years ago
Solved

leaf Level View

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...
Need Help
Tips and Tricks
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    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

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
Anil2264
Icon for Helper I rankHelper I
4 years ago

Hi Anonymous 

 

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's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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