Forum Discussion

siva54's avatar
siva54
Helper I
4 years ago
Solved

Asset Description with same class

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

Need Help
  • Fowmy's avatar
    Fowmy
    4 years ago

    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" )

     



3 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    4 years ago

    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's avatar
    wdx223_Daniel
    Community Champion
    4 years ago

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

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    4 years ago

    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.