Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Create Measure to Sum Up Column Total Based on User Picking Date

I'm trying to write a measure that sums up the entire column based on a user picking a date on a slicer.    This is what I have so far:    CalculatePastDue = CALCULATE(SUM(Invoice[AmtUSD]),FILTER...
Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    8 years ago
    Anonymous wrote:

    Thank you for replying. For some reason it's adding a lot more values (6.8 M). I added the data table into the original question for a frame of reference.

    Anonymous

    What is the date column in the slicer? Vvelarde's DAX shall work based on my test. Alternatively, you can create a measure as simple as sumTotal = SUM(Invoice[AmtUSD]) and use "BEFORE" in the slicer. See attached pbix file.

     

    For further suggestion, please post upload the pbix file. You can upload it to Onedrive/GoogleDrive and share the download link. Do remember to mask sensitive data before uploading.

Vvelarde's avatar
Vvelarde
Community Champion
8 years ago

Anonymous

 

Hi try with this:

 

CalculatePastDue = CALCULATE(SUM(Invoice[AmtUSD]),FILTER(All(Invoice),Invoice[PaidDate] <= SELECTEDVALUE(DateTable[Date])))

 

Regards

 

Victor

Lima -peru

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thank you for replying. For some reason it's adding a lot more values (6.8 M). I added the data table into the original question for a frame of reference.

    • Eric_Zhang's avatar
      Eric_Zhang
      Microsoft Employee
      8 years ago
      Anonymous wrote:

      Thank you for replying. For some reason it's adding a lot more values (6.8 M). I added the data table into the original question for a frame of reference.

      Anonymous

      What is the date column in the slicer? Vvelarde's DAX shall work based on my test. Alternatively, you can create a measure as simple as sumTotal = SUM(Invoice[AmtUSD]) and use "BEFORE" in the slicer. See attached pbix file.

       

      For further suggestion, please post upload the pbix file. You can upload it to Onedrive/GoogleDrive and share the download link. Do remember to mask sensitive data before uploading.