How to Flag CUST_ID from SALES table ?

[admin11]

Hi All

I am able to flag Customer/Vendor Code from AR Table , using below measure :-

_FLAG TOP_AR = IF ( ( AR[Customer/Vendor Code] IN { "A10002" } ), 1, 0)

Why i am not able to Flag from SALES Table ?

_FLAG TOP_SALES = IF ( ( SALES[CUST_ID] IN { "A10002" } ), 1, 0)

i Get below error msg :-

A single value for column 'CUST_ID' in table 'SALES' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

Remark :- 

My Sales Table have field name = CUST_ID

CUST_ID field is Text format

My PBI file :-

https://www.dropbox.com/s/k6p44smuk8g156r/PBT_V2021_393%20TI_SI_GL%20FLAG%20CUST%20ID%20FROM%20SALES...

Paul

Paul Yeo

[PhilipTreacy · Accepted solution]

@admin11 

Hi Paul,

Download PBIX

That error is generated when you are trying to create a Measure and haven't provided an aggregation (like MAX) for the column.  Or you tried to create the column in the wrong table.

If you create the column in the Sales table then it works.  Is this what you want?

_FLAG TOP_SALES = IF ( ( SALES[CUST_ID] IN { "A10002" } ), 1, 0)

Regards

Phil

[admin11]

@PhilipTreacy 

i learn one more new thing , the field i want to create need to create at SALES table . 

Paul