Showing [Profit%] values less than 50.

[Anonymous]

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%

[amitchandak · Accepted 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.