Alternate set - drilldown?

oddgeir — Wed, 27 Sep 2023 07:30:02 GMT

How do I apply a filter (by selection in table) to all states in an Alternate set?

Is it by design that I can't filter rows if I'm using alternate set, or am I doing something wrong?If i'm using alternate set in measures the table doesn't narrow down to selected values anymore. If I'm removing the column using alternate set it behaves as expected.

This is the measure causing confusion

Sum({[Old Snapshot]}QTY)

This does not affect the table

Sum(QTY)

My plan was to use Alternate set as a way to find discrepancies between two snapshots (New Snapshot - Old Snapshot), but usability is a pain if drilldown in all other dimensions has to be coordinated manually. ( I can drill down if I use separate filters assigned to each state). It's also a risk if someone misses one filter on one of the dimensions.

Some data to play around with

Data: Load * Inline [ Name , Dept , Worked , Snapshot , QTY Anne , A , 2023-05 , 2023-08 , 100 Ben , A , 2023-05 , 2023-08 , 100 Charlie , C , 2023-05 , 2023-08 , 100 Dina , C , 2023-05 , 2023-08 , 100 Anne , A , 2023-06 , 2023-08 , 100 Ben , A , 2023-06 , 2023-08 , 100 Charlie , C , 2023-06 , 2023-08 , 100 Dina , C , 2023-06 , 2023-08 , 100 Anne , A , 2023-07 , 2023-08 , 100 Ben , A , 2023-07 , 2023-08 , 100 Charlie , C , 2023-07 , 2023-08 , 100 Dina , C , 2023-07 , 2023-08 , 100 Anne , A , 2023-05 , 2023-09 , 100 Ben , A , 2023-05 , 2023-09 , 100 Charlie , C , 2023-05 , 2023-09 , 110 Dina , C , 2023-05 , 2023-09 , 100 Anne , A , 2023-06 , 2023-09 , 100 Ben , A , 2023-06 , 2023-09 , 110 Charlie , C , 2023-06 , 2023-09 , 100 Dina , C , 2023-06 , 2023-09 , 100 Anne , A , 2023-07 , 2023-09 , 100 Ben , A , 2023-07 , 2023-09 , 110 Charlie , C , 2023-07 , 2023-09 , 100 Dina , C , 2023-07 , 2023-09 , 100 ];

Visualization

topic Alternate set - drilldown? in App Development

Alternate set - drilldown?