count unique record based on several columns

hi, i have a question regarding unique records. i have the following table: key description release 111 item for sale rel1 111 item for sale rel1 111 item for sale rel2 111 ...

Need Help

SpartaBI
4 years ago
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

In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.

SpartaBI Logo

Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook

Showcase Report – Contoso By SpartaBI
SpartaBI
4 years ago
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

In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.

SpartaBI Logo

Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook

Showcase Report – Contoso By SpartaBI

SpartaBI

Community Champion

4 years ago

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

In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.

SpartaBI Logo

Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook

Showcase Report – Contoso By SpartaBI