Forum Discussion
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...
@req7 Try this measure. I uploaded a PBIX file below.
Measure = COUNTROWS( SUMMARIZE( FILTER( 'Table (2)', [CV ] <> 11.1 && [CV ]<>11.2 ), [COD ],[CV ] ) )
@req7 Try this measure. I uploaded a PBIX file below.
Measure =
COUNTROWS(
SUMMARIZE(
FILTER(
'Table (2)',
[CV ] <> 11.1 && [CV ]<>11.2
),
[COD ],[CV ]
)
)