Forum Discussion
Running total in Power Pivot based on other measure with missing values in certain months
Hi Greg,
not sure, I get what solution do you propose in the attached file. What modification to the measures [RT Sales1] or [RT Sales2] can you propose to make it look like in the column *What I need:* I have added manually.
The [AvgPrice 2023] and the [RT Sales1] measures are calculated first by product A and B in separate pivot table.
So [RT Sales1] works correctly by product, but doesn't work by product by month together.
Greg_Deckler Thanks for your contribution on this thread.
Hi PivotRiot ,
Did you get the solution? If no, could you please provide some sample data (exclude sensitive data) with Text format and the calculation logic of measure [AvgPrice 2023], [RT Sales1] and [What I need] with the speicial examples and screenshot? It would be helpful to find out the solution. You can refer the following link to share the required info:
How to provide sample data in the Power BI Forum
And it is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
In addition, you can refer the following links to try to solve your problem...
Why Your Total Is Incorrect In Power BI - The Key DAX Concept To Understand
Dax for Power BI: Fixing Incorrect Measure Totals
Best Regards