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.

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

Hi,

Please show me your slicer.

I think there are two spaces.

One is showing -10, right?

How about the other?

I think.... selectedvalue is not working if your slicer is not selecting only one number.

If you do not want to change the type of the slicer, try to amend the measure using MIN, not selectedvalue.

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

abc_777's avatar
abc_777
Icon for Solution Specialist rankSolution Specialist
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.