Getting duplicate code after the conditional formatting

Question

I have table name Called LocalFPV . this table have a following columns&nbsp;&nbsp;if&nbsp; W[g]_1&nbsp;&nbsp;column have a null value we need to create column showing the alert "Warning" or if&nbsp; weight column have a value it will show&nbsp; "Available".&nbsp;I have created new calculated column like below&nbsp;&nbsp;alert 1 = IF(LocalFPV=BLANK(),"Warning","Available")&nbsp;but when i applied the alert column in to the&nbsp; table . i am getting duplicate record like below&nbsp;Summary sheet"ItemCode&nbsp; &nbsp; &nbsp; &nbsp;plant&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;W[g]_1&nbsp; &nbsp;GrossWeightMeasure&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Netweightmeasure&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AlertFA1021.1&nbsp; &nbsp; &nbsp; &nbsp; IDGF&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.246&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3.567&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2.733&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Available&nbsp; &nbsp; &nbsp; -- Correctone&nbsp;FA1021.1&nbsp; &nbsp; &nbsp; &nbsp; IDGF&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1.246&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1.875&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Warning&nbsp; &nbsp; &nbsp;-- Wrong one&nbsp;FA1022.11&nbsp; &nbsp; &nbsp; IT04&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3.345&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3.567&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2.733&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Available&nbsp; &nbsp; &nbsp; -- Correctone&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;FA1022.11&nbsp; &nbsp; &nbsp;&nbsp;IT04&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3.345&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1.875&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;Warning&nbsp; &nbsp; &nbsp;-- Wrong one&nbsp;even tired condition formatting method also&nbsp; getting above result only&nbsp;&nbsp;But Correct result&nbsp;&nbsp;ItemCode&nbsp; &nbsp; &nbsp; &nbsp;plant&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;W[g]_1&nbsp; &nbsp;GrossWeightMeasure&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Netweightmeasure&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AlertFA1021.1&nbsp; &nbsp; &nbsp; &nbsp; IDGF&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.246&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3.567&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2.733&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Available&nbsp; &nbsp; &nbsp; -- Correctone&nbsp;&nbsp;FA1022.11&nbsp; &nbsp; &nbsp; IT04&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3.345&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3.567&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2.733&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Available&nbsp; &nbsp; &nbsp; -- Correctone&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;I am looking for support .. thanks in advance ..&nbsp;

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
If creating a calculated column in a summary table?
Alert 1 = IF('Summary sheet'[W[g]]_1]=BLANK(),"Warning","Available")
&nbsp;
Best Regards,GaoCommunity Support Team
&nbsp;
If there is any post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;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.&nbsp;Thanks a lot!
How to get your questions answered quickly&nbsp;--&nbsp;How to provide sample data
&nbsp;

anonymous · Answer

Anonymous&nbsp; &nbsp;both sheet values coming from Local FPV&nbsp; sheet only&nbsp;

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
It's a little weird.&nbsp;Is this a table or a table visual?&nbsp;Use this measure if it is table visual.
&nbsp;
Alert 1 = IF(MAX('LocalFPV'[W[g]]_1])=BLANK(),"Warning","Available")

&nbsp;
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
&nbsp;
Best Regards,GaoCommunity Support Team
&nbsp;
If there is any post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;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.&nbsp;Thanks a lot!
How to get your questions answered quickly&nbsp;--&nbsp;How to provide sample data

Forum Discussion

Getting duplicate code after the conditional formatting

3 Replies

Related content

Conditional Formatting

Conditional Formatting using DAX

Conditional Formatting

Matrix Row Conditional Formatting

Condition formatting