title: PowerBI Matrix Average instead of Subtotal and Conditional Formatting According to That Average
body: <p>Hello I am just new in powerBI and it is still hard to work on for me.
  I have a matrix like that</p>
  <pre><code>DATE     Sales      Refund
  26 Agu      45          5
      p1      10          3
      p2      15          2
      p3      20          0
  27 Agu      60          1
      p1      15          1
      p2      20          0
      p3      25          0 
  </code></pre>
  <p>In the date parts I have subtotals as it normally does. However, I want to show the average of that day there and when I get the average I will make conditional formatting according to it. If a cell is below average I will mark it with red point and in refunds I will do it for the values above the average.
  Is there a way to do that. I searched for it for awhile but could not find.</p>
  <p>The output I want is like that. (star is for red point.)</p>
  <pre><code>DATE     Sales      Refund
  26 Agu      15          1.66
      p1      10*         3*
      p2      15          2*
      p3      20          0
  27 Agu      20          0.33
      p1      15*         1*
      p2      20          0
      p3      25          0 
  </code></pre>
  <p>Thanks.</p>