I have a Hierarchical slicer. Top Level is MARepcat; second level is MAReport.
SInce the slicer is on a menu page I need details of the selected items to appear in a card.
The following works when selecting items ONLY from the 2nd level:
CONCATENATEX(ALLSELECTED(MAReports[MA Report]),MAReports[MA Report],",")
But when the Top level is selected all possible (selected and unselected) MAReports are returned.
So how do we make it only return the level 2 ones when a top level node is selected??