topic Re: Asset Description with same class in DAX Commands and Tips

Asset Description with same class

siva54 — Tue, 26 Oct 2021 05:32:10 GMT

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

Re: Asset Description with same class

wdx223_Daniel — Tue, 26 Oct 2021 07:28:51 GMT

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

Re: Asset Description with same class

Fowmy — Tue, 26 Oct 2021 08:44:26 GMT

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

Re: Asset Description with same class

v-yanjiang-msft — Thu, 28 Oct 2021 07:06:05 GMT

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.