Cumulative Total of several tables

[Anonymous]

Hi,

I'm working on a project, and I'd like to make a cumulative total with data coming from different tables.

I have been through a lot of forums and tried different techniques but I can't seem to make this work.

Here are the tables I have 

All historiques and PBI-Releve are data tables filtered by the calendar table using Date and PBI-ID Table using Attribute (name)

The cumulative sum actualy works but doesn't follow the filters on my page

As you can see it's cumulating but from the first date ever, regardless of the year I'm asking (which is from calendar table)

The measure is as follow

Chaud cumulé = CALCULATE([Conso chaud gen],filter(ALLSELECTED('calendar'[Date]),'calendar'[Date]<=max('calendar'[Date]) ))

Conso chaud gen = (CALCULATE(sum(Historique2[Value]),filter('PBI-ID','PBI-ID'[Nom compteur]="chaud gen"))+

CALCULATE(sum(Historique1[Value]),filter('PBI-ID','PBI-ID'[Nom compteur]="chaud gen"))+

CALCULATE(sum('PBI-Relevés'[Value]),filter('PBI-ID','PBI-ID'[Nom compteur]="chaud gen")))/1000+

CALCULATE(SUM(HistoricLogs[Conso_1.m3_2.MWh]),FILTER(HistoricLogs,HistoricLogs[TagReference]="vtCompteur2"))

HistoricLogs isn't linked to PBIID, only to calendar and by Date as well

I Hope I am clear enough, please if anyone has an idea or questions I'll be glad to answer

Thanks in advance

[Greg_Deckler]

@Anonymous - It's difficult to follow what might be going on here. Could have something to do with the ALLSELECTED function. Do you really need that? Are you saying it isn't following your filters because it doesn't start at zero?

[Anonymous]

@Greg_Deckler Hi, 

thanks for you're reply! I don't "need" allSelected it is just something i tried after ALL function and ALLEXCEPT. If you have any other function I would love to try it out !

That's what I'm saying indeed. When I don't apply any filter it starts from 0 and does a cumulative sum. Yet, it is supposed to start from 0 when i choose a time period.

I have data starting 2017, I would like to be able to select 2019 and know exactly how much has been consumed on 019 starting at 0 to see the evolution during the year.

Have a good day

[v-deddai1-msft]

Hi @Anonymous ,

It is really hard to say what's going on in your measure.Would you please inform us more detailed information( your  data(by OneDrive for Business)) if possible? Then we will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.

Best Regards,

Dedmon Dai