How to convert my expression from measure to column ? so i can use t as filter pan.

[admin11]

Hi All

I have a list out stand debtor :-

I need to filter first 2 row customer ID as high risk customer :-

I have below Measure , no error , but due to it is a measure , i am unable to use it as filter panel or Slicer , can some one advise how to convert to column ?

_HIGH_RISK_NEW_ =

SUMX (

AR, 

IF (

AR[Customer/Vendor Code] IN {"A10002","AR10012"},

0,

AR[AR_AMT_]

)

)

My PBI file :-

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

Paul Yeo

[selimovd]

Hello @admin11 ,

the following calculated column should make it:

New Column = IF( AR[Customer/Vendor Code] IN { "A10002", "AR10012" }, 0, AR[AR_AMT_] )

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[admin11]

@selimovd 

I get error msg on below field :-

[Customer/Vendor Code]

I cannot post the image to show you the error.

Paul

[selimovd]

@admin11 and would you also like to share the error message with me?

[admin11]

@selimovd 

Error msg :-

https://www.dropbox.com/s/mw0r9ip38fc4m1s/error.png?dl=0

Paul

[selimovd]

@admin11  

I think you added it as a measure and not as a calculated column.

Try to add it as a calculated column.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[admin11]

@selimovd 

Yes you are correct , after i change to column , the error msg changes.

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

image of error msg :-

https://www.dropbox.com/s/30abga4v57ztxz0/error%20new.png?dl=0

Below is my PBI file :-

https://www.dropbox.com/s/4bqjd0kpzpt5al8/PBT_V2021_392%20TI_SI_GL%20filter%20hi%20risk%20coy%20get%...

[selimovd]

Hey @admin11 ,

what exactly should the measure [AR_AMT_] do?

If it should return BLANK if the column AR[A/R amount include GST in LC] = 0 then try the following code for the column:

New Column =
VAR vAR_AMT =
    IF(
        AR[A/R amount include GST in LC] = 0,
        BLANK(),
        AR[A/R amount include GST in LC]
    )
RETURN
    IF( AR[Customer/Vendor Code] IN { "A10002", "AR10012" }, 0, vAR_AMT )

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[admin11]

@selimovd 

Thank you this time no more error , But i am not able to use it for Slicer or Fliter Pan.

https://www.dropbox.com/s/prvjoq2rtax07aj/CAN%20NOT%20USE%20FOR%20FILTER%20OR%20SCALIER.png?dl=0

Can you make it return 1 or 0 , so that i can use Slicer to filter high risj customer.

Paul

[selimovd · Accepted solution]

Hey @admin11 ,

sure, try that one:

New Column = IF( AR[Customer/Vendor Code] IN { "A10002", "AR10012" }, 0, 1 )

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[admin11]

@selimovd 

Finally working fine now. Thank a lot .

What are the mistake I have make in asking this question ? it is because when i post this question intially i give the expression in measure give confuse to you ? 

Paul

[selimovd]

Hey @admin11 ,

I'm happy it finally worked 🙂

Yes, I think the problem was that you cannot always convert a measure to a column as the concepts are different. I think someone would have answered faster if you would have explained that you want to use that as a slicer and for that reason you have to add it as a column.

But eventually you got it working 🙂

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi