Tick and X measure when date are the same

[Anonymous]

Hi Experts

I have a date sclier (from FACT Table) and a measure from DimDate table if the dates from the date Slicer = The date from the measure then tick otherwise x. The measure from DimDate is in a card.

My FACT table = Control Tab

So far my measure

TickandCross =

VAR Tick = UNICHAR(128504)
VAR Tick = UNICHAR(128500)

I want record the Checks in a table

[amitchandak · Accepted solution]

@Anonymous , Not very clear

Try a measure like

measure  =

var _date = maxx(allselected(Table), Table[Date])

return

calculate(if(max(Date[Date]) = _date,UNICHAR(128504), UNICHAR(128500)))

[Anonymous]

Hi Amit - Ill upload a excel file example...to drop box