Filter rows

[aymeric_kolan]

Hi all,

I need your help, I don't find solution alone.

I would like identify by ID, #ID where I have only one row with a critea at "Entree_SVI" (see example, results attended is in red).

How I can filter on row?

Table: DATA SVI_2

Colums:

- InboundCallVoice_CallId

- FilterId

Example:

EI228-C21872	Platinum
EI228-C21872	Entree_SVI
EI228-C22096	Platinum
EI228-C22096	Entree_SVI
EI228-C22467	Platinum
EI228-C22467	Platinum_Renvoi
EI228-C22467	Platinum_Transf
EI228-C22467	Entree_SVI
EI228-C22880	Platinum
EI228-C22880	Entree_SVI
EI228-C22880	Entree_Ferm
EI228-C22880	Platinum_Ferm
EI228-C23484	Entree_SVI
EI228-C23485	Entree_SVI
EI228-C23486	Entree_SVI

[Greg_Deckler]

Measure = IF(CALCULATE(COUNT([InboundCallVoice_CallId]),FILTER('DATA SVI_2',[FilterId]="Entree_SVI")),1,0)

[aymeric_kolan]

Hi smoupre.

Thanks but when I used code , it showed "1"
But I would like "3" with my example because there is only 3 ID where there is only one row with "Entree_SVI"

Mesure = IF(CALCULATE(COUNT('DATA SVI_2'[InboundVoiceCalls_CallId]);FILTER('DATA SVI_2';[FilterId]="Entree_SVI"));1;0) 

[Greg_Deckler]

 Turn it into a column and just SUM the column.

[aymeric_kolan]

Thank you for your time but request doesn't return answer I need.

I need to know how many ID I have with only one row "Entree_SVI".

When one ID had more than one row, I don't need to count it.

[v-yulgu-msft · Accepted solution]

Hi @aymeric_kolan,

Please use below DAX formula to create a calculated table which only returns three rows that are highlighted in red.

Table_1 =
CALCULATETABLE (
    'DATA SVI_2',
    FILTER (
        'DATA SVI_2',
        CALCULATE (
            COUNT ( 'DATA SVI_2'[FilterId] ),
            ALLEXCEPT ( 'DATA SVI_2', 'DATA SVI_2'[FilterId] )
        )
            = 1
            && 'DATA SVI_2'[InboundCallVoice_CallId] = "Entree_SVI"
    )
)

Best regards,
Yuliana Gu