Power Pivot Running Total with multiple filters (category)

Yoga Fendi 20

I have tried to run a calculate daxs (Running Total) for this table with power pivot measures, like below :

RunningTotal=

CALCULATE(SUM([AMOUNT]),FILTER(ALLSELECTED([DATE],[DATE]<=MAX([DATE]) && [GLACCOUNT] =MAX([GLACCOUNT]) && [IDSTORE]=MAX([IDSTORE]))))

But, output is ERROR.

t User's image

Any expert who can help me, please :)

thank's alot for your attention..

Accepted answer

Tanay Prasad 2,140 Reputation points

2023-06-07T07:09:41.2166667+00:00

Hi,

This seems to have a syntax error. Here's the corrected version of the expression:

RunningTotal = CALCULATE( SUM([AMOUNT]), FILTER( ALLSELECTED([DATE]), [DATE] <= MAX([DATE]) && [GLACCOUNT] = MAX([GLACCOUNT]) && [IDSTORE] = MAX([IDSTORE]) ) )

Please let me know if this works.

Best Regards.
Please sign in to rate this answer.
Yoga Fendi 20 Reputation points

2023-06-07T07:21:33.02+00:00

Hi Tanay,

Thank's alot for your attention & help,

This below is my power pivot actually & still ERROR.

Could you help me please about syntax formula in column RunningTotal.

thanks

Yoga Fendi 20 Reputation points

2023-06-07T07:24:52.8733333+00:00

Hi Tanay,

Thank's alot for your attention & help me.

Below is my power pivot real data & syntax still ERROR for RunningTotal.

Please help me

Tanay Prasad 2,140 Reputation points

2023-06-08T07:29:19.81+00:00

Hi Yoga,

Ensure that the data types of the columns used in the formula match the expected types. For example, if the [AMOUNT] column is numeric, make sure it is formatted as a numeric data type in Power Pivot.

Check if there are any null values or unexpected data values in the columns used in the formula. You can use the DAX functions like ISBLANK or ISERROR to handle potential issues with null values.

Confirm that the relationships between the tables involved in the calculation are properly established in your Power Pivot data model. Verify the cardinality (one-to-one, one-to-many, many-to-many) and the direction of the relationships.

If the issue persists, please provide more information about your data model, including the table structures, relationships, and sample data.

Yoga Fendi 20 Reputation points

2023-06-12T01:46:26.17+00:00

thank you so much mr. Tanay,

as your suggestion, it's been done.

Tanay Prasad 2,140 Reputation points

2023-06-12T05:41:22.5533333+00:00

@Yoga Fendi

If my answer helped you, I'd appreciate it if you can mark it as an Accepted Answer. :D

Have a great day ahead.!
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

1 additional answer

Herbert Seidenberg 1,191 Reputation points

2023-06-09T17:00:12.7166667+00:00

Excel 365 Pro Plus with Power Pivot and Power Query.
Running total.
With PivotChart and Slicer.
https://www.mediafire.com/file_premium/j5reog3exgntnem/06_09_23.xlsx/file
https://www.mediafire.com/file_premium/nnt4v7i3epuvv6l/06_09_23.pdf/file
Please sign in to rate this answer.

1 person found this answer helpful.
Yoga Fendi 20 Reputation points

2023-06-12T01:49:17.5933333+00:00

thank you so much mr. herbert,

I'll try to go trough with your share references.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Power Pivot Running Total with multiple filters (category)

1 additional answer

Your answer