Forum Discussion

siva54's avatar
siva54
Icon for Helper I rankHelper 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{ F...
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" )

     



wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
4 years ago

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