Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
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 |
Solved! Go to 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
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
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.
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
User | Count |
---|---|
82 | |
76 | |
71 | |
69 | |
54 |
User | Count |
---|---|
105 | |
100 | |
91 | |
79 | |
68 |