I hope a DAX ninja warrior can suggest a thing or two for me to try. Because I have run out of ideas.
Please see the attached images for the challenge.
I have 12 what-if parameters, one for each month of the year, and I am able to “flex” /incorporate these with values from other tables in the model.
At the total level, no matter what I try, the total does not show any values.
For comparison I have included the results from the original column of values that I am trying to flex.
My approach at the total level has been to try to do what has been demonstrated on Enterprise DNA by Sam, by using virtual tables, but the virtual table seems to be empty when it gets to the total level.
I cannot share the actual .pbix file owing to the nature of the company information contained. I do hope the image of the DAX code and the output provides enough context.
Can someone kindly explain what I am missing and suggest some way(s) I can “encourage” the selected values within the SWITCH statement to stay/be present within the virtual table?
Would be very much appreciated.