Forum Discussion
admin11
Memorable Member
Memorable MemberHow to filter GP % more then 50% ?
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
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))
2 Replies
- amitchandak
Super User
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