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