Forum Discussion
Solved
Need Bottom 3 rows data
Hello Team , I need small help to write dax or any soltion for below issue. - I have requirment were i need to find bottom3 rows . below is Dummy Example for your referance - Source data- ...
Hi SAPpowerbi ,
Whether your Value filed is a measure or a calculated column, you need to be clear about this. There is still a difference between the two.
Can you enter the Power Query Editor? If you can, you can create a index in it.
Then use TOP N to filter.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Bottom 3 rows: =
VAR bottom3table =
TOPN ( 3, ALL ( Data ), CALCULATE ( MAX ( Data[Category Name] ) ), DESC )
RETURN
CALCULATE ( SUM ( Data[Value] ), KEEPFILTERS ( bottom3table ) )