mesaure dynamic text (Active or Expired)  based on date Colum (Contract End Date)

Abdulazizsagga Try:

Column = IF(TODAY()>[End Date],"Active","Expired")

Measure = IF(TODAY()>MAX('Table'[End Date],"Active","Expired")

Hi Abdulazizsagga 

If you want the card visual to show blank until you select one contract, you can try this,

Measure = IF(ISBLANK(SELECTEDVALUE('Table'[contract])),BLANK(),IF(SELECTEDVALUE('Table'[End Date])<TODAY(),"Expired","Active"))

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.