Incorrect total of measure

[Anonymous]

Hi All,

I have tried all possible ways that i found to calcualte the Measure total but did not succeed.

I have measure that calculate the total volume of customers for last 12 months, the measure works fine and return correct result.

But the total of the measure column ("HL R12 CY") is not the sum of all the values of the measure column.

HL R12 CY = calculate (
SUM('Datas Vol'[Total Volume]),
DATESBETWEEN( 'Dates'[date],
max( 'Dates'[Date])- 365,
max ('Dates'[Date])))

[v-kelly-msft · Accepted solution]

Hi  @Anonymous ,

Create a measure as below:

_HL R12=SUMX(VALUES('Datas Vol'[POC SAPID]),[HL R12 CY])

See my sample data below:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[v-kelly-msft · Accepted solution]

Hi  @Anonymous ,

Create a measure as below:

_HL R12=SUMX(VALUES('Datas Vol'[POC SAPID]),[HL R12 CY])

See my sample data below:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous · Accepted solution]

Thanks this solution worked

[PhilipTreacy]

Hi @Anonymous 

You'll need to supply your data/PBIX file in order for this to be checked.

Regards

Phil

[MattAllington]

Some thoughts:

how do you know it's not working?  Have you checked the difference between actual and expected and tried to see if there is matching data?

Are you following the rules for calendar tables? https://exceleratorbi.com.au/power-bi-calendar-tables/

I think you would be better to use datesinperiod 

[Anonymous]

The measure is working fine, it the total line which is incorrect.

What i am looking for is to have a Sum of the column "HL R12 CY" in total line.

I exported the result to excel and when i manually check the total is different than what we currently have in the image total 8561.88