Calculated Field

[Anonymous]

I've used Tableau in the past for clients. However with this new client we are using Power BI. 

I'm trying to create a field

=if(count(distinct MissingProduct)<1 'No Missing Products', 'Missing Products')

However i'm getting an error. "Syntax for MissingProduct' is incorrect.

Any advice?

I tried breaking up the calculation to just count distinct products, and getting an error about count function. 

Thanks in advance 

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but please try the below if it suits your requirement.

create a field =
IF (
    DISTINCTCOUNT ( 'Tablename'[MissingProduct] ) < 1,
    "No Missing Products",
    "Missing Products"
)

[Anonymous]

I think this has worked. Will let you know