Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Create a measure:
Items for selected Group =
VAR selectedGroup = SELECTEDVALUE(Data[Group])
VAR itemsTable =
CALCULATETABLE(
VALUES(Data[Item]),
TREATAS({selectedGroup}, Data[Group])
)
RETURN
IF(
ISBLANK(selectedGroup),
"Select a group",
CONCATENATEX(itemsTable, Data[Item], ", ")
)
Add this measure into a Card visual or Table visual.
If your slicer already filters the table through a relationship, you can simplify it:
Items for selected Group =
IF(
HASONEVALUE(Data[Group]),
CONCATENATEX(VALUES(Data[Item]), Data[Item], ", "),
"Select one group"
)
If you need to limit the number of displayed items, use this version:
Items for selected Group =
VAR selectedGroup = SELECTEDVALUE(Data[Group])
VAR allItems = CALCULATETABLE(VALUES(Data[Item]), TREATAS({selectedGroup}, Data[Group]))
VAR topItems = TOPN(50, allItems, Data[Item])
VAR total = COUNTROWS(allItems)
RETURN
IF(
ISBLANK(selectedGroup),
"Select a group",
IF(
total > 50,
CONCATENATEX(topItems, Data[Item], ", ") & " โฆ +" & FORMAT(total - 50, "#,0") & " more",
CONCATENATEX(allItems, Data[Item], ", ")
)
)