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.