topic Re: Dax comand for card visual in DAX Commands and Tips

Dax comand for card visual

nanacobsbs — Fri, 27 Jan 2023 02:11:31 GMT

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?

Re: Dax comand for card visual

wdx223_Daniel — Fri, 27 Jan 2023 02:38:17 GMT

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)

Re: Dax comand for card visual

nanacobsbs — Fri, 27 Jan 2023 04:30:10 GMT

Thank you for your reply.

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

Re: Dax comand for card visual

wdx223_Daniel — Fri, 27 Jan 2023 07:50:34 GMT

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]))

Re: Dax comand for card visual

nanacobsbs — Fri, 27 Jan 2023 08:34:28 GMT

Yes!! It works!!!

Thank you very much.