Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Getting duplicate code after the conditional formatting

I have table name Called LocalFPV . this table have a following columns    if  W[g]_1  column have a null value we need to create column showing the alert "Warning" or if  weight column have a valu...
Help appreciated
Help me
Help Request
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

If creating a calculated column in a summary table?

Alert 1 = IF('Summary sheet'[W[g]]_1]=BLANK(),"Warning","Available")

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Anonymous   both sheet values coming from Local FPV  sheet only 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Anonymous ,

       

      It's a little weird. Is this a table or a table visual? Use this measure if it is table visual.

       

      Alert 1 = IF(MAX('LocalFPV'[W[g]]_1])=BLANK(),"Warning","Available")

       

      If this doesn't work, please share a pbix flie without sensitive data, that will help me find the cause of the problem faster. Thanks in advance.

      How to provide sample data in the Power BI Forum

       

      Best Regards,
      Gao
      Community Support Team

       

      If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

      How to get your questions answered quickly -- How to provide sample data