Item group slicer

[Anonymous]

<p>Hi,</p><p> </p><p>I have a matrix visual with customers (rows), item groups (columns) and sales.</p><p> </p><p>I would like to build a slicer that contains the item groups and shows all the customers with sales in the selected item group.</p><p>I also want to see the sales in the selected and the non-selected item groups. </p><p> </p><p>When I add a slicer with item groups I can see all the customers with their sales in this group but the other item groups disappear.</p><p> </p><p>Is there any possibily to build a slicer like that?</p><p> </p><p>Thank you very much!</p><p> </p><p>Thomas</p>

[v-luwang-msft]

Hi @Anonymous ，

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[amitchandak]

@Anonymous , first of all you need an independent item group slicer

then you can have meausre like

selected = calculate([meausre], filter(Table, Table,[item group] in allselected( 'item group'[ item group]) ))

not selected =

var _tab = except( all( 'item group'[ item group]) ,allselected( 'item group'[ item group]) )

return

calculate([meausre], filter(Table, Table,[item group] in _tab ))

If you need them with a column(having measure names)  , the create a calculation group 

Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0