Skip to main content
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

View discussion in a popup

Replying to:
technolog
Super User

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], ", ")
)
)

 

View solution in original post