Forum Discussion

sajal161292's avatar
sajal161292
Icon for Helper V rankHelper V
8 years ago

To calculate the total dynamically

Hi,   I am stuck up in calculating a running total for one of my reports.In the image given beloww i would basically liske to adjust the on hand demand like the one shown below.   Presently...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI sajal161292,

 

>>Is there any way to perform iteration in DAX and traverse for each record?

It is possible to achieve this, but you need to add huge amount of conditions to help measures confirm where current content calculated. 

 

In my opinion, power bi not support auto/dynamic calculate on complex measures(exist some specific filters, contains break row contents function e.g. 'all/allexcept').

 

Notice: if your data contains any privacy data, please do mask sensitive data before sharing.

 

Regards,

Xiaoxin Sheng

sajal161292's avatar
sajal161292
Icon for Helper V rankHelper V
8 years ago

Hi,

 

So will it be possible to perform this operation in DAX?

 

Thanks

Har**bleep**a Singh