Forum Discussion
Formatting rows unique to only one table visual
Hi, Anonymous
You can try the following methods.
Measure = VAR _table1=CALCULATETABLE(VALUES(Table1[Commodity number]),FILTER(ALL(Table1),[BM number]=MAX(Table1[BM number]))) VAR _table2=CALCULATETABLE(VALUES(Table2[Commodity number]),FILTER(ALL(Table2),[BM number]=MAX(Table2[BM number]))) VAR _table3=CALCULATETABLE(VALUES(Table3[Commodity number]),FILTER(ALL(Table3),[BM number]=MAX(Table3[BM number]))) RETURN SWITCH(TRUE(), SELECTEDVALUE(Table1[Commodity number]) in EXCEPT(_table1,UNION(_table2,_table3)),1, SELECTEDVALUE(Table2[Commodity number]) in EXCEPT(_table2,UNION(_table1,_table3)),1, SELECTEDVALUE(Table3[Commodity number]) in EXCEPT(_table3,UNION(_table1,_table2)),1,0)Color measure = IF([Measure],"Yellow",BLANK())Then add conditional formatting to each field.
Is this the result you expected?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous,
Thank you for your efforts! Unfortunately for my data, the measure could only identify some unique ingredients and missed out on a few, and some non-unique ingredients were highlighted. This occurs in all three table visuals, but it is still pretty close. I will try and find out if there is a pattern to the mistakes.
Could trailing spaces in the commodity numbers affect the outcome and make a non-unique commodity number appear unique? But this does not account for when a unique commodity number is not flagged as unique (1).
Thanks again!
Hi, Anonymous
Spaces in the field are what affect the results of the calculation.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous,
I just trimmed all the commodity number columns but the result is still the same, are there any other formatting issues that I should check for? Thank you so much!
Hi, Anonymous
Can you provide example files?
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Best Regards
Hi Anonymous ,
I am unable to attach the sample file now as it is blocked, but I hope this table with an excerpt of the real data can help! Thank you very much
BM1 61441 Vanilla flavor 5 BM1 1492 Precipitated calcium carbonate 4 BM1 1430 Sodium citrate 3 BM1 1444 Choline chloride 2 BM2 1735 Whey protein 6
BM2 1111 Coconut oil 7 BM2 1146 sunflower oil 2 BM2 1115 MCT oil 1 BM2 61441 Vanilla flavor (artificial) 2 BM4 61441 Vanilla flavor 3 BM5 61441 Vanilla flavor 2