I have a table with customers and products recommended for each customer and the date that the recommend was made, and I would like to calculate the recommended sales that I had for each customer and each product after the recommendation date.
But I'm getting out of memory. There is something wrong in my DAX, or there is another way to do this measure?
# Sales After Recommender =
VAR recommender_date= MINX('recommendations', 'recomendations'[date])
VAR Customer_= SELECTEDVALUE('recomendations'[customer])
VAR Product_ = SELECTEDVALUE('recomendations'[product])