Forum Discussion
How does SELECTEDVALUE work?
Hi, I'm trying to create a personal budget report. What I'd like to achieve is to select a month from a slicer and have a matrix visual give me my cash flow for the selected month by account. But...
Hi,
"SelectedValue returns the value when the context for columnName has been filtered down to one distinct value only. Otherwise returns alternateResult". And if the alternate result is not specified, it is blank.
This holds even, when the multiple selected values are equal. But even this is not the case as your fiscal months cross the calendar months.
I have no time to go into your model. However, something like Calculate(Firstnonblank([CalendarMonth],0),
Filter(DateTable, [Year-Month] = BudgetCode)) and then cast to an integer could do the trick.
Perhaps this helps. If you are still stuck, let me know.
Best regards
Christian