Forum Discussion

JuanBolas's avatar
JuanBolas
Helper II
3 years ago
Solved

Visual table duplicating values

Hello,   I'm trying to set up a summary table of week number, route, tickets sold, available seats, and occupancy rate. Week number comes from a date table. Route and tickets sold are from one tab...
  • v-jianboli-msft's avatar
    3 years ago

    Hi JuanBolas ,

     

    Please add the Filter 'For Occupany‘[Route] is PJL -PBA (or 'For Occupany‘[Route] is PBA-PJL) to the two tables:

    Final output:

    Best Regards,

    Jianbo Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.