Forum Discussion
Calculated Field
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
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" )
2 Replies
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" )