Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Cumulative DAX Measure Error

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 ...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    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.

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

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