Hi @rit372002, It’s great to know your query has been solved, and thank you for sharing the solution. We’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!
1 Like
Hi Ritesh,
Brilliant, good for you. I was hoping to see the solution in Power BI.
Take care,
Mariusz
Got solution in PBI as well.
What you suggested pretty much worked with a caveat of, I needed to put the TOPN filter on grower in the filter pan. After doing that, and selecting one Retailer, it didn’t spin for forever and gave the result right away. Here is the solution from mahoneypat.
Thanks again!
Ritesh