PowerBi Filters not display correct values - TOPN

Question

I am having a dataset that rank profiles based on revenue and I have selected profiles that ranks lower than 30 using the filter and from that 30 I need 5 Profiles and I am not getting a proper result

Answer 1

Use the following DAX function

IF ( [Rank] <= 30 ; SUM ( Sales[Bud Diff] ) ; BLANK() )

Are you willing to learn power bi? Check the Power BI Developer blog from Intellipaat

Also, watch our YouTube video on Power BI Courses to get yourself started.: