Forum Discussion

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...

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  ]
        )
    )