Forum Discussion

abc_777's avatar
abc_777
Icon for Solution Specialist rankSolution Specialist
5 years ago
Solved

where is my error

Hi   is anyone help me out from my error please   Sale Total N days = VAR ndaysselect = SELECTEDVALUE ('N Days Sale'[MS Forum N Days Sale]) RETURN SUMX ( FILTER ( BMCalendar, BMCalendar[...
Need Help
  • abc_777's avatar
    abc_777
    5 years ago

    Man you r genuus.

     

    you r right. Seriouslly your sight is perfect. in slicer I mistakenly change to greate than or equal to and thats because its made this issue.

    now i changed to single value and now its perfectly working

     

    thanks jihwan really you r genious.

abc_777's avatar
abc_777
Icon for Solution Specialist rankSolution Specialist
5 years ago

yes. what ever number i give in -10 or -12 its not showing any value i check the formula servral time and compaire with your but couldd't found any error. even for quantity its working greate as i told you yesterday but same formula for sales its not working

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Also, try to check if your calendar table is connected to your fact table.

Also, try to check if your calendar table is marked as a date table.