Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

DAX formula issue

I have 5 DAX conditions and an IF condtion to return the measure result. The IF comparison condition is returning the result of only the month selected in Month slicer instead of returing last 3 mont...
Need Help
vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
5 years ago
are you able to provide some data? so basically what you saying is you want your measure to ignore the slicer? how are you using this measure?
Anonymous's avatar
Anonymous
Not applicable
5 years ago

The variable orders_3M in  IF condition- if(((Orders_1>=Orders_2)&&(Orders_2>=Orders_3)&&(Orders_3>=Orders_4)),orders_3M, BLANK()) is not returning last 3 months data based on month slicer selection.

 

For ex- For month selection Apr, it returns data of Feb and Apr instead of Feb, Mar, Apr. 

(Orders_1>=Orders_2)&&(Orders_2>=Orders_3)&&(Orders_3>=Orders_4) condition holds TRUE.

 

I am using this measure in a Column chart with Values as the 'measure name' and Axis as 'month'.

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    5 years ago
    to be honest its hard to see whats going on without having some data to look at, have you checked each measure to see what its returning?