It’s difficult to diagnose specifically what the problem is here without seeing your data model, PBIX file or a mockup of the results you want to see. However, based on information provided I think these two videos may be helpful to you.
Thanks very much for providing the data. I apologize for the slow response – I’ve been largely consumed this week getting the new Power BI Accelerator initiative rolling. Will dig into this today and hopefully have a solution back to you by this evening.
Hi @Aree, we’ve noticed that no response has been received from you since the 22nd of June. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.
Hi @Aree, due to inactivity, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.