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)

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.

...