Forum Discussion

PBI_STARTER's avatar
PBI_STARTER
Regular Visitor
4 years ago
Solved

Filter on > then Value

Hello All, I have a table called SALES. I need to show  Product, Revenue, and Margin of Top 3 Product by Margin of products where Revenue is > 49 and Margin is also positive. Also only need Top 3 ba...
Need Help
  • tackytechtom's avatar
    tackytechtom
    4 years ago

    Hi PBI_STARTER ,

     

    I see two quick ways:

     

    1) use the filter pane and select the filters according to your requirements:

     

     

    2) you create a ranking measure, and drag it also in to the filter pane:

     

     

    Here the measure:

    TopNMeasure = 
RANKX ( ALLSELECTED ( Table ), CALCULATE ( MAX(Table[Revenue] ), Table[Revenue] > 49, Table[Margin] >= 0 ) )

     

    Let me know if this helps 🙂

tackytechtom's avatar
tackytechtom
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

Hi PBI_STARTER ,

 

I see two quick ways:

 

1) use the filter pane and select the filters according to your requirements:

 

 

2) you create a ranking measure, and drag it also in to the filter pane:

 

 

Here the measure:

TopNMeasure = 
RANKX ( ALLSELECTED ( Table ), CALCULATE ( MAX(Table[Revenue] ), Table[Revenue] > 49, Table[Margin] >= 0 ) )

 

Let me know if this helps 🙂