Asset Description with same class

[siva54]

Hi Team,

I need a calculated column for the below criteria.

we have differnent asset classes with different asset description with their codes.

Here, For Example:- Asset Description are{ Fan, Pen, Chair, Table....}
                                Asset Classes Like{A,B,C....}

                                Codes{H,I..}

Here, Class "A" have Asset description like Fan and Pen. then These two asset description should not associate with Other Classes like{B,C..} with in the Same code. then result is Not Anamoly.
If the description are associated with other classes in Same Code then it is Anamoly.

Find the below Capture.

In above picture, Asset class A have Fan and Pen with Code "I". But Pen is associated with Asset class "C" with Same code I, then all "pen" are Anamoly

Fan is Associated with Asset Class B, But with different Code, then it is fine &  it's should be not Anamoly.

Thanks in Advance.

If the code is different then it is fine

[v-yanjiang-msft]

Hi @siva54 ,

According to your description, here’s my solution.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy · Accepted solution]

@siva54 

Add the following column:

Check = 

VAR _DES = Table1[Asset Description]
VAR __CLASS = Table1[Asset class]
VAR _CODE = Table1[Code]
VAR _LIST = CALCULATETABLE( VALUES(Table1[Code]), Table1[Asset Description] = _DES , Table1[Asset class] <> __CLASS, REMOVEFILTERS( ) )
RETURN
    IF ( _CODE IN _LIST , "ANAmoly" , "Not An" )

[wdx223_Daniel]

Final Out Put=IF(CALCULATE(DISTINCTCOUNT(TableName[Asset class]),ALLEXCEPT(TableName,TableName[Asset description]))>1,"Anamoly","Not Anamoly")