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.

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.