Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
5 years ago
Solved

How 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 B...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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's avatar
    admin11
    Icon for Memorable Member rankMemorable Member
    5 years ago

    amitchandak 

    Thank you it work fine using filter pan.

    Paul