count unique record based on several columns

yuvalpi OKK 🙂 So I didn't understand what you meant.
This is the column you need:

Column 2 = 
VAR _current_key = 'Table'[key]
VAR _result = 
    CALCULATE(
        DISTINCTCOUNT( 'Table'[release] ),
        REMOVEFILTERS('Table'),
        'Table'[key] = _current_key
    )
RETURN
    _result

      

Showcase Report – Contoso By SpartaBI

yuvalpi you mean like this?:

Column 2 = 
VAR _current_key = 'Table'[key]
VAR _result = 
    CALCULATE(
        DISTINCTCOUNT( 'Table'[release] ),
        REMOVEFILTERS('Table'),
        'Table'[key] = _current_key,
        'Table'[release] <> BLANK()
    )
RETURN
    _result

      

Showcase Report – Contoso By SpartaBI