Forum Discussion

dbattin4's avatar
dbattin4
Frequent Visitor
9 months ago
Solved

Running Total Measure Won't Work With Filters

I have a running total Measure that is working Revenue Budget Running Total =  CALCULATE(  SUMX(BudgetByProduct,[REVENUE_BUDGET]),  FILTER(ALLSELECTED('Calendar'[global_date]),'Calendar'[global_...
Need Help
Tips and Tricks
  • dbattin4's avatar
    dbattin4
    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


Praful_Potphode's avatar
Praful_Potphode
Super User
9 months ago

Hi dbattin4 

 

as mentioned by MFelix  please provide more information on input/output.

i tried replicating your measures in PBI desktop.

Most of them are working fine.the only time you will get blank for the second measure is when you select anything else than "IRT".Sample PBIX can be donwloaded from here.

 

 

Please give Kudos or mark it as solution once confirmed.

 

Thanks and Regards,

Praful