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

     

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