Double distinct count

[Anonymous]

Hello, everyone 🙂
My table follows this structure:

COD	CV
111	11.1
111	15.2
111	16.2
222	11.2
222	16.2
333	11.1
333	15.2
333	15.2

I would like to create a measure that distinct counts all types of CVs that are neither 11.1 nor 11.2, for each distinct COD. 
So, in the example table above, the count should be:

COD 111 = 2 (CV 15.2 and CV 16.2)
COD 222 = 1 (CV 16.2)
COD 333 = 1 (CV 15.2)

So, the measure should bring me the value 4 (2 +1 + 1).

Can someone help me?

[Ashish_Mathur]

Hi,

This measure works

=SUMX(SUMMARIZE(VALUES(Data[COD]),Data[COD],"ABCD",CALCULATE(DISTINCTCOUNT(Data[CV]),Data[CV]<>11.1,Data[CV]<>11.2)),[ABCD])

Hope this helps.

[Greg_Deckler · Accepted solution]

@req7 Try this measure. I uploaded a PBIX file below.

Measure = 
    COUNTROWS(
        SUMMARIZE(
            FILTER(
                'Table (2)',
                [CV  ] <> 11.1 && [CV  ]<>11.2
            ),
            [COD  ],[CV  ]
        )
    )

[amitchandak]

@Anonymous , Try like

sumx(Values(Table[COD ]),calculate( distinctCOUNT(Table[CV]) filter(Table, not(Table[CV] in {11.1 , 11.2}))))

sumx(Values(Table[COD ]),calculate( distinctCOUNT(Table[CV]) filter(Table, not(Table[CV] in {"11.1" , "11.2"}))))