How to filter GP % more then 50% ?

[admin11]

Hi All

I have an expression below :-

GP % YTD = DIVIDE(([Sales YTD] - [COST YTD]),[Sales YTD])

it generate the GP % from 0% till 100%

I like to filter for GP % more then 50% .

I have try Below , i get error :-

My PBI sample file 

https://www.dropbox.com/s/8su0l3kh446krbb/PBT_V2021_400%20GL_TI_1.pbix?dl=0

Paul

[amitchandak · Accepted solution]

@admin11 , On is use visual level filter on GP % YTD > =.5 (In the filter pane)

Or create a measure based on a group column of visual

calculate([GP % YTD], filter(Values(Table[BrancC-Internal]), [GP % YTD] >=.5))

[admin11]

@amitchandak 

Thank you it work fine using filter pan.

Paul