title: Bottom5 and top5 with DAX formulas and slicers
body: <p>I hope you are all well.</p>
  <p>I have a file here where I have two worksheets:
  On the “Sheet1”, I have a table with sites, number of overdues and periods.
  <img src="https://i.stack.imgur.com/F8c1R.png" alt="enter image description here" /></p>
  <p>On “Sheet2”, I have a green pivot table that I have created using data modeling.</p>
  <p>The question that I have is that (please, check the data modeling) I have created a DAX formula to show the top5 values. The issue that I am facing is that it is considering both periods and that´s why, the green pivot table is only showing three sites: Barcelona, Bologna, and Nettetal. Instead of that, it should show Bologna, Nettetal, Barcelona, Sydney, and Cartago.
  Additionally, I cannot find any formula to show the bottom5 ones.</p>
  <p>What I want to do with the slicers is to show the top5/bottom5 per each period Q1/Q2.</p>
  <p>Can you please help me?</p>
  <p>Thanks
  viewotst</p>