Forum Discussion

portizparedes's avatar
portizparedes
New Member
8 years ago
Solved

Matrix only show first or last value

So we are building this matrix and it get filtered with a timeslicer so in the matrix when a certain date is pick it will show which event is on that date. But if I have two different events on the same day or week it only show one, because in the matrix value you have to pick if you want to show the first or the last and there is no "all" option. Any thoughs on how to fix this?

  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    portizparedes,

     

    A measure always operates on aggregations of data under the evaluation context. The context depends on user selections in the report or on the shape of the DAX query.

5 Replies

    • portizparedes's avatar
      portizparedes
      New Member
      8 years ago

      Thanks but I need to group the info in columns by month so the matrix was really useful. If there is no w ay to do it I will have to change to table but it will not be what I really wanted to present the info.