Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 ...
Need Help
Show and Tell
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    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"
)
Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    I think this has worked. Will let you know