Back

Explore Courses Blog Tutorials Interview Questions

PowerBi Filters not display correct values - TOPN

0 votes
2 views
in BI by (11.1k points)

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

enter image description here

1 Answer

0 votes
by (22.5k points)

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.:

Related questions

0 votes
0 answers
In PowerBI Desktop how can we display the filters selected in the Report
asked Dec 28, 2020 in BI by Chris (11.1k points)
0 votes
1 answer
PowerBI - Dynamic TopN + Others depending on slicer
asked Dec 26, 2020 in BI by Chris (11.1k points)
0 votes
1 answer
How to display a vertical “time” line over a visual made in PowerBi?
asked Feb 9, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
How can I display values in Power BI 100% Stacked Bar?
asked Apr 6, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
Bolding values in PowerBI
asked Dec 28, 2020 in BI by Chris (11.1k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

30.5k questions

32.5k answers

500 comments

108k users

Browse Categories

© COPYRIGHT 2011-2023 INTELLIPAAT.COM. ALL RIGHTS RESERVED.

Download Salary Trends Now !

Learn how professionals like you got up to 100% Salary Hike.

...