Forum Discussion

AjithTravvise's avatar
AjithTravvise
Icon for Helper II rankHelper II
6 years ago
Solved

dax

Hello All,     I am very new DAX and I mapush to work on this because of current situation. Please look into the below scenario and help me calculate the DAILY VALUE   Table Name : Sales Count...
  • Pragati11's avatar
    Pragati11
    6 years ago

    Hi AjithTravvise ,

     

    In your DAX formula, replace "ALL" with "ALLSELECTED".

    This will take into consideration any filters you are applying like the COUNTRY.

     

    If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

     

    Thanks,

    Pragati

     

AjithTravvise's avatar
AjithTravvise
Icon for Helper II rankHelper II
6 years ago

Hi Greg,

 

     This worked, but when I am applying filter by Country its not working

Regards

Ajith 

  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    6 years ago

    Hi AjithTravvise ,

     

    In your DAX formula, replace "ALL" with "ALLSELECTED".

    This will take into consideration any filters you are applying like the COUNTRY.

     

    If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

     

    Thanks,

    Pragati

     

    • AjithTravvise's avatar
      AjithTravvise
      Icon for Helper II rankHelper II
      6 years ago

      What i noticed is if the value is 0 it returns -ve figure.