Cumulative DAX Measure Error

[Anonymous]

Hi Experts

I cannot see the error in my cumulative DAX Measure - See sample data. The first table in the below give the standard hourly units sold in the second table i am trying to work out the cumulative sale.....

https://www.dropbox.com/s/fc0x835a4tgxnx1/Tes.pbix?dl=0 

[Jihwan_Kim]

Hi, @Anonymous 

I am not sure if I understood your question correctly, but please check the below picture and the sample pbix file's link down below.

Number of units sold =

SUMX(FACTSalesOrderTable,1)

Number of unit sold cumulate =

CALCULATE (

[Number of units sold],

FILTER (

ALL ( FACTSalesOrderTable ),

FACTSalesOrderTable[Created_Hour] <= MAX ( FACTSalesOrderTable[Created_Hour] )

)

)

https://www.dropbox.com/s/d4rexy7nmeqlagt/Tes.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[Anonymous]

hi Kim - have a look at this link and the cumulative table...in this file..
https://www.dropbox.com/s/i30tqiy7p0j1z93/Test.pbix?dl=0 

PS Do not re post the same file. Just the dax where the error is and steps please.

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

1. if you want to use ALL function, then please try to only remove the filter for the specific column. If you use ALL function for the whole table, I think it will also remove the filter for currency.

2. for the specific currency, there is no result for the calculated column. In order to do cumulative calculation, please try to use another column in another table that represents the hour.

3. Because you said do not upload the file, I don't upload the file. I just suggest like above.

thanks.

[Anonymous]

Uplaod the file... and remove it once i have downloaded it - ill message you,,....still confused....thanks

[Anonymous]

Hold on - ignore last message.

[Anonymous]

Hi Kim. Can you do the Cumulative of the sum of the Created hours in the first table....

[Jihwan_Kim]

Hi, @Anonymous 

I could not.

Because it is an implicit measure and I could not do the cumulative sum by using the implicit measure.

And I did not understand what was the meaning of that implicit measure. It was just summing the numbers. I could understand it if the implicit measure was COUNT. However, I could not understand what was the meaning of SUM. 

If you still want to calculate the cumulative, then I suggest creating the explicit measure and use this to create the cumulate calculation. 

[Anonymous]

Hi Kim Just posted a new file....i am trying to get the second table correct as a cumulative

[Anonymous]

Hi Kim 

Can you kindly assist with the following

https://community.powerbi.com/t5/Desktop/Items-Per-Order-DAX-Measure/m-p/1848229#M714191

And thanks for all your help...