Power Pivot Running Total with multiple filters (category)

Question

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..

Answer accepted by question author

1 additional answer

Your answer

Answer 1

Tanay Prasad 2,255

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.

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,255 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,255 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.!

Answer 2

Herbert Seidenberg 1,201

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

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.

Share via

Power Pivot Running Total with multiple filters (category)

1 additional answer

Your answer