How to create column expression to filter high risk account ?

[admin11]

Hi All

_HIGH RISK = IF( AR[Customer/Vendor Code] IN {

A10002,AR10012

}, "HI RISK", AR[AR_AMT_])

I get below error msg

A circular dependency was detected: AR[Column 2], AR[_Day 1 to 31 column], AR[Column 2].

Below is my PBI file :-

https://www.dropbox.com/s/nxopagvvhdqceoq/PBT_V2021_392%20TI_SI_GL%20how%20to%20filter%20high%20risk...

Paul

[themistoklis]

@admin11 

In the if statement it seems you try to combine text ("HIGH RISK") with number which cannot be done.

Create a measure and add the following formula. Make sure you delete any other error fields (the ones with the exclamation mark symbol) in the table as i saw that these prevent the formula from displaying

_HIGH_RISK_NEW = 
SUMX (
    AR,    -- Table Name
    IF (
        AR[Customer/Vendor Code] IN {"A10002","AR10012"},
        0,
        AR[AR_AMT_]
    )
)

[admin11]

@themistoklis 

Many thank for your sharing.

Kindly help me change the expression from measure to column. 

As i am unable to place the measure at Slicer or filter panel.

Paul

[v-janeyg-msft · Accepted solution]

Hi, @admin11  

The file is deleted, it is difficult for me to understand the situation.

According to the response above, You can create a column.

Like this:

_HIGH_RISK_NEW =
SUMX (
    FILTER ( AR, [a] = EARLIER ( AR[a] ) && [b] = EARLIER ( AR[b] ) ),
    IF ( AR[Customer/Vendor Code] IN { "A10002", "AR10012" }, 0, AR[AR_AMT_] )
)

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

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