Need Same values corresponding to ID Column

siva54 — Tue, 05 Oct 2021 11:09:35 GMT

Hi Team,

I need calculated column based on category and cat Id,

Some category have catid and some not have.

example:- for category "Pen11" have catid"1001" for all "Pen11" catid should be Same. If catId is blank then blank.

Re: Need Same values corresponding to ID Column

PaulOlding — Tue, 05 Oct 2021 11:15:46 GMT

You could do it by returning the max catid per category

Result = CALCULATE(MAX('Table'[catid]), ALLEXCEPT('Table', 'Table'[Category]))