Dax comand for card visual

[nanacobsbs]

I would like to have a card next to a graph visualizing sales performance and Target, showing the ratio to Target for the month selected by the slicer.
I would also like to set a threshold value and have it configured to change the background of the card depending on the value.
I created the following code, but when I put it in the card, it is blank and I cannot set the color.
Is it possible to have the numbers on the table appear on the card?

Please help again.

VS Target = IF(MAX('Calendar'[Date]) = MAX('Date for slicer'[Date]), DIVIDE(SUM('Budget Control'[Actual]),SUM('Budget Control'[Target])))

I have a sample pbix file and tried to upload here, but coudn't due to the follwing error message.
error  message:The file type (.pbix) is not supported.

What is wrong?

 

[wdx223_Daniel]

because in the card visual, there is no filter context on the calendar table, so the condition of IF is FALSE, and give you a blank.

VS Target = VAR _date=MAX('Date for slicer'[Date]) RETURN CALCULATE(DIVIDE(SUM('Budget Control'[Actual]),SUM('Budget Control'[Target])),'Calendar'[Date]=_date)

[nanacobsbs]

Thank you for your reply.

I copied the dax code, but it is still blank.

[wdx223_Daniel · Accepted solution]

does this work?

VS Target = VAR _date=VALUES('Date for slicer'[Date]) RETURN CALCULATE(DIVIDE(SUM('Budget Control'[Actual]),SUM('Budget Control'[Target])),TREATAS(_date,'Calendar'[Date]))

[nanacobsbs]

Yes!! It works!!!

Thank you very much.