Filter Weekly Totals by Company when both weekly totals are returned in 1 row

[sharmon9000]

I was trying to figure out a way to filter by company when the weekly totals are returned on 1 row by week.

Example of returned row from database:

| WeekEnding  |   Company1   |  Company2  |
  2019-07-27       2500           3500
  2019-07-20       2200           3350
  2019-07-13       2600           3450

It was easy to combine the totals by week using a measure and SUM to combine both totals. But is it possible to have a filter where the TOTAL will be updated depending on if Company1 or Company2 or Both is selected?

[Anonymous · Accepted solution]

@sharmon9000 - When more than one column are essentially the same data, it is best to "Unpivot" the columns. The easiest way to unpivot columns is in Power Query. Click "Edit Queries" to open the Power Query Editor, and then do the following:

1. Select Transform tab.

2. Select "WeekEnding" column.

3. Click the arrow next to"Unpivot Columns". 

4. Click "Unpivot Other Columns".

I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.