Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

dax - circular reference error with two measures using same filter

Hi All,   I am trying to create slicers based of sales quantity (no sales) over time. I can create the first measure which works well however if I create a second one with a different date filter I...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , refer to this blog, how can you get no sales by just using ins blank

https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retention/ba-p/1377458

 

example

 

Rolling 3 =

var _1=  CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],eomonth(MAX('Date'[Date]),0),-3,MONTH))

 

return

if(isblank(_1), 1, 0)

 


Rolling 6 before 6 =

var _1 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],eomonth(MAX('Date'[Date]),-6),-6,MONTH))

 

return

if(isblank(_1), 1, 0)