Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi
I am trying to figure out how to display Profit% values below 50% only or have the option to exclude values above. As profit% is a measure i am having trouble understanding the logic to do this. Ideally, a slicer would be useful. Otherwise perhaps there is a better measure that will only show values less than 50%
FYI, i am using Excel Powerpivot to do this and not powerBI.
Project Number | [Sales] | [Profit] | [Profit%] |
3 | 300 | 200 | 67% |
1 | 100 | 50 | 50% |
6 | 600 | 300 | 50% |
4 | 300 | 50 | 17% |
5 | 400 | 60 | 15% |
2 | 200 | 10 | 5% |
Solved! Go to Solution.
@Anonymous , Best is to have a visual level filter [profit %] <50 %
Else you have do this for all measures in visual
example measure for profit % and Sales
AverageX(Filter(Summarize(Table[Project Number],"_1",[Profit %]),[_1]<50),[_1])
SumX(Filter(Summarize(Table[Project Number],"_1",[Profit %],"_2",[sales]),[_1]<50),[_2])
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.
@Anonymous , Best is to have a visual level filter [profit %] <50 %
Else you have do this for all measures in visual
example measure for profit % and Sales
AverageX(Filter(Summarize(Table[Project Number],"_1",[Profit %]),[_1]<50),[_1])
SumX(Filter(Summarize(Table[Project Number],"_1",[Profit %],"_2",[sales]),[_1]<50),[_2])
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.