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

     

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

HI AjithTravvise ,

 

Can you please provide some details on how you want this DAILY VALUE to be caluclated? There is no reference in your question to what you want and it's impossible to answer.

 

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