Forum Discussion

Anil2264's avatar
Anil2264
Helper 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 each FG it should not populate the rest levels, only leaf level to be populated.

amitchandak  dax 

Current View
FGL1L2L3L4
A    
A123   
A123876  
B    
B222567  
B222567678 
B222567678987

 

 

Output
FGL1L2L3L4
A123876  
B222567678987
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

     

3 Replies

  • 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
      Helper 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
        Community 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