highlight the entire row if there are duplicates in dimension

[sangeetha_changu]

Approval No_9digit is extracted from Approval No. 

If the Approval No_9digit is same and repeating, need to highlight the entire row

Attached screenshot

[AshutoshBhumkar]

Hi,

You can try using If & Previous.

If(ApprovalNo_9digit = Previous(ApprovalNo_9digit), Yellow())

(Sort data on DepotDate)

Thanks,

Ashutosh

[sangeetha_changu]

this didn't work

[Frank_Hartmann]

maybe this expression:

if(count( Total <[Approval No_9digit]> [Approval No_9digit]) > 1 , LightGreen())

or

Aggr(NODISTINCT If(count([Approval No_9digit]) > 1, LightGreen()), [Approval No_9digit])

[sangeetha_changu]

this didnt help