Counting Repeated Details

Hi all,

Sample file: Sample PBIX

I have a table like this,

I would like to show a Card visual like this,

If I select an ID in slicer as "1", I need to have values shown on the card. Please ref the below screenshot,

How can I acheive the above result?

Thanks in Advance.

Anonymous

Edited

Create the measure below and place it in a card visual

Check it out in this file

NewMeasure =
VAR _Total =
    COUNT ( Sales[Detail] )
VAR _AuxTable =
    ADDCOLUMNS (
        SUMMARIZE ( Sales; Sales[ID]; Sales[Detail] );
        "_Count"; CALCULATE ( COUNT ( Sales[Detail] ) )
    )
VAR _MaxCount =
    MAXX ( _AuxTable; [_Count] )
VAR _TotalMax =
    SUMX ( FILTER ( _AuxTable; [_Count] = _MaxCount ); [_Count] )
VAR _OutputText =
    CONCATENATEX (
        FILTER ( _AuxTable; [_Count] = _MaxCount );
        [_Count] & " - " & [Detail];
        UNICHAR ( 10 )
    )
VAR _FirstLineText = _TotalMax & "/" & _Total
VAR _AllText =
    _FirstLineText & UNICHAR ( 10 ) & _OutputText
RETURN
    _AllText

Forum Discussion

Counting Repeated Details

6 Replies

Related content

Count repeating values

Paginated Report headers not repeating

Counting repeat customers

Counting nulls

Count repeating values