Solved: Re: Calculated Field

Anonymous · ‎08-29-2022

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 · ‎08-29-2022

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

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Jihwan_Kim · ‎08-29-2022

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

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Anonymous · ‎08-29-2022

I think this has worked. Will let you know

Calculated Field