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

Now i am unable to generate a daily sales report since i have only incremental values. I wanted to break it down to daily. I hope i am clear with my requirement.

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

Hi AjithTravvise ,

 

Simple question - How can you generate daily sales if you don't have data for it? As you say you have got incremental values not daily values.

 

Thanks,

Pragati

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

    Hi Pragati,

     

         I need help in creating a measure for calculate the daily sales value.

    Regards

    Ajith