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
Anonymous's avatar
Anonymous
Not applicable
5 years ago

 Amit,

 

The first issue I see is that I cannot use Blanks as I have many records that are actually blank and I need to exclude these. I need this to work only when the value is == 0. The second is that I wish to use this measure as a slicer.. as in True or False. I do like your example. Thank you.

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , you can try like

Rolling 3 =

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

 

return

if(_1 =0 , 1, 0)