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, abc_777 

I cannot see clearly but I guess your parameter's number is -10 (negative number), right?

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

    How does your [total sales measure] look like?

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


      total sales measure =
      SUMX('bm_all_cul bm_sales_dhk_all_cul',
      ('bm_all_cul bm_sales_dhk_all_cul'[SQty] ----- sold quantity
      -
      'bm_all_cul bm_sales_dhk_all_cul'[rQty]) -----return quantity
      *
      'bm_all_cul bm_sales_dhk_all_cul'[RPU])----- unit price

      so get actual sale amount

      global calendar table is connected i can confirmed you coz in same power bi file i can see quantity
      is working with same calendar table but not sales

      • 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

  • 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.