Forum Discussion

Ry5's avatar
Ry5
Icon for Helper I rankHelper I
4 years ago
Solved

Show First 3 selected values then a count

Hi,   I have a slicer and am using a card on which I want to show the first 3 selections, then a count of how many additional selections have been made.   I can make it show the first three OR a co...
  • OwenAuger's avatar
    OwenAuger
    4 years ago

    Ry5 try this:

    Top 3 Measure =
-- Rename to ItemList & [Item] to simplify code
VAR ItemList =
    SELECTCOLUMNS (
        VALUES ( 'Table'[SlicerColumn] ),
        "Item", 'Table'[SlicerColumn]
    )
VAR _Count =
    COUNTROWS ( ItemList )
VAR _Top3 =
    TOPN ( 3, ItemList, [Item], ASC )
VAR _Concat =
    CONCATENATEX ( _Top3, [Item], ", ", [Item] )
RETURN
    _Concat
        & IF ( _Count > 3, " + " & ( _Count - 3 ) & " more" )

    Regards, Owen

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Ry5 , Try a measure like

 

VAR _Count = COUNTROWS( VALUES ('Table'[SlicerColum]) )
VAR _Top3 = CONCATENATEX( TOPN( 3, allseleccted('Table'[SlicerColumn]), _Count, ASC), [SlicerColumn] )
RETURN _Top3

Ry5's avatar
Ry5
Icon for Helper I rankHelper I
4 years ago

Hi, Thank you for the reply but this didn't work. It returns a full list of everything in the slicer. Even if I only select one option.

  • OwenAuger's avatar
    OwenAuger
    Icon for Super User rankSuper User
    4 years ago

    Ry5 try this:

    Top 3 Measure =
-- Rename to ItemList & [Item] to simplify code
VAR ItemList =
    SELECTCOLUMNS (
        VALUES ( 'Table'[SlicerColumn] ),
        "Item", 'Table'[SlicerColumn]
    )
VAR _Count =
    COUNTROWS ( ItemList )
VAR _Top3 =
    TOPN ( 3, ItemList, [Item], ASC )
VAR _Concat =
    CONCATENATEX ( _Top3, [Item], ", ", [Item] )
RETURN
    _Concat
        & IF ( _Count > 3, " + " & ( _Count - 3 ) & " more" )

    Regards, Owen

    • Ry5's avatar
      Ry5
      Icon for Helper I rankHelper I
      4 years ago

      Thank you, yes this works!