Forum Discussion
Running Total Measure Won't Work With Filters
- 9 months ago
I have resolved this by changing the order of the creation of the measures.
Created a filtered sum then created another measure for the running total of that sum
Hi dbattin4 ,
Without any further information or example is difficult to give you the exact problem. Not sure what you are using this calculation for but have you tried the visual calculations, there is a running sum that will be applied to the visual you are working with.
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-visual-calculations-overview
But if you want to reuse this one for sure you need a measure.
Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.
I have resolved this by changing the order of the creation of the measures.
Created a filtered sum then created another measure for the running total of that sum
- MFelix9 months agoSuper User
Hi Praful_Potphode ,
Glad you were able to solve it don't forget to accept as solution the correct answer so it can help others, even if it is yours.
- Praful_Potphode9 months agoSuper User
Thank you so much MFelix