Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Double distinct count

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 cre...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

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

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

    Greg_Deckler_0-1599614257208.png

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

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"}))))