Aircraft Circle Indicator measure not working in Shape Visual

[krishnakanth240]

Hi All,

I had a question with Aircraft circle Indicator measure

Test Color Ind =

VAR v1 = SELECTEDVALUE(ccc[type display])

VAR v2 = SELECTEDVALUE(ccc[contract status])

VAR L12M = TODAY() - 365

VAR L24M = TODAY() - 730

VAR CD = SELECTEDVALUE(ccc[changedate])

VAR CID = SELECTEDVALUE(ccc[contractid])

VAR IsCC = IF(CID IN VALUES(Aircraft[contractid]), "current", "previous")

RETURN

IF ( IsCC = "current",

SWITCH (TRUE(),

v2 = "Terminated", "#000000",

v2 = "Suspended", "#FF0000",

v2 = "Active" && v1 = "Suspended" && CD <= TODAY() && CD >= L12M, "#FF0000",

v2 = "Active" && v1 = "Suspended" && CD <= L12M && CD >= L24M, "#FFBF00", "#00FF00" ))

For this measure, colour in Shape Visual is not picking correctly because in ccc table there is more than one record for each aircraft like the data of rows are: Date 19 Jan 2024, cs is Active, td is Enrollment Date 9 Jan 2024, cs is Active, td is Suspended Date 28 June 2023, cs is Active, td is Enrollment Date 14 June 2023, cs is Active, td is Enrollment Because of this kind of data of rows in Shape Visual it is not picking.

Filter on this page I have Aircraft serial number(from aircraft table) to filter and check the logic for each aircraft.

Now based on this challenge and situation Can anyone suggest whether is this possible to achieve with the change in the measure.

Thank you in advance

[lbendlin]

 in ccc table there is more than one record for each aircraft 

and which one do you want to use? Do you have a column that you can use as a filter (for example last modified date)?

[krishnakanth240]

Yes, in corporate care change table there is more than one record for each aircraft serial number

To filter, using aircraft serial number column(from Aircraft table) in Filter on this Page

Yes there is a column with Change date which says when the aircraft status changes to Enrollment, Suspended, Transfer, etc