Forum Discussion

jay13's avatar
jay13
Regular Visitor
1 year ago
Solved

Countrows with filters

I am trying to count the rows for an ID where they only have a specific code.   Example: If I am looking to count the IDs that only have code D how would I count just that row. In this case the cou...
Need Help
  • Gabry's avatar
    Gabry
    1 year ago

    Hello jay13 

     

    this is your measure

    ContaSoloD =
    CALCULATE (
        DISTINCTCOUNT ( Tabella[ID] ),
        FILTER (
            VALUES ( Tabella[ID] ),
            CALCULATE ( COUNTROWS ( FILTER ( Tabella, Tabella[code] <> "D" ) ) ) = 0
        )
    )

    let me know if it works
SachinNandanwar's avatar
SachinNandanwar
Impactful Individual
1 year ago

Just incase if you want to return ID's that only have one instance of "D"

Table_1 = 
VAR _Table = 
    SUMMARIZE(
        'Table',
        'Table'[ID],
        "Codes", DISTINCTCOUNT( ( 'Table'[code] )),
        "Codes_D",COUNTROWS( FILTER( 'Table', 'Table'[code] = "D" ))
    )

RETURN  FILTER(_Table,[Codes]=[Codes_D])