Hi Egbejiogu, as mentioned above, to help the experts ans users in assisting you, it would be helpful if you provide the demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, and any other supporting links and details.
We have also have threads with some recommendations from other Power BI users which could help. Below are the links where you can view them. Hope this helps.
