Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help with Circular Reference Error

Hello Power BI Gurus,   I am stuck with an issue where I have created a few measures and one of the measure is erroring out because of circular reference. It have tried many alternatives but haven'...
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , this sequence of measure is not correct,

     

    Create a cumulative measure and try like

     


    Cumm cases last month = CALCULATE(sum(Monthlypayments[Total case]),filter(allselected(date),date[date] <=maxx(date,dateadd(date[date]),-1,year)))
    cases this month = sum(Monthlypayments[Total case])

    paid this month = Quotient(mod([Cumm cases last month],40) + [Cumm cases this month], 40)

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , this sequence of measure is not correct,

 

Create a cumulative measure and try like

 


Cumm cases last month = CALCULATE(sum(Monthlypayments[Total case]),filter(allselected(date),date[date] <=maxx(date,dateadd(date[date]),-1,year)))
cases this month = sum(Monthlypayments[Total case])

paid this month = Quotient(mod([Cumm cases last month],40) + [Cumm cases this month], 40)

Anonymous's avatar
Anonymous
Not applicable
5 years ago

That's Brilliant Amit! Thanks a lot for this quick solution! I was struggling to get the Cumulative sum working as I use using Max in the data comparison rather than MAxx function.  This really helped me get through the blocker. Thanks again for your help