For this it would be better to pivot your Qx columns.
To do so, select all Qx measures (ctlr-click), then right-click and select Transform - Pivot
This give you a new measure "Pivot Field Values", and a new dimension "Pivot Field Name".
Right-click and drag Pivot Field Values on the Filter, select all values, and filter to keep only the 1s.
Drag, Pivot Field Name on the filter shelf, and use it as the Quarter selector.
Book2 (mc).twbx 195.1 KB
I did try the pivot method….the problem with this is that it creates extra rows of data, so the sum of my total spaces becomes over 17,000
Then you can create a parameter and create a filter like this
when 'Q4 2018' then if [Q4 2018] = 1 then 1 else 0 end
when 'Q1 2019' then if [Q1 2019] = 1 then 1 else 0 end
when 'Q2 2019' then if [Q2 2019] = 1 then 1 else 0 end
when 'Q3 2019' then if [Q3 2019] = 1 then 1 else 0 end
when 'Q4 2019' then if [Q4 2019] = 1 then 1 else 0 end
when 'All' then if [Q4 2018] = 1 and
[Q1 2019] = 1 and
[Q2 2019] = 1 and
[Q3 2019] = 1 and
[Q4 2019] = 1
then 1 else 0 end
else 0 end
and keep the 1s
Book2 (mc2).twbx 195.5 KB
This solution worked Michel - thank you for your help!