I have the below data table.
For actual DIV BPS i'm using the below calculation:
Actual Div BPS = SUM('LoanMaster (2)'[Div Concession $])/Sum('LoanMaster (2)'[Loan Amount])
It's not pulling correctly when I have either a Date or Sales Person Slicer applied. Not sure how to get this to work.
Go to Solution.
Figured it out! had to do Measures not columns! 1 for each total then divide!
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.