Cumulative sum of past months

[knut12212]

My measure returns the correct result, but when I try to filter by a specific product, only zero values appear. In other words, the product filter is being ignored by the measure.

What would be the best way to solve this problem?

 

Running Total Revenue =
VAR MaxPastMonths = MAX ( 'Sales Data'[Number of past months] )
VAR CurrentMonth = MAX ( 'Sales Data'[Months (as number)] )
RETURN
IF (
CurrentMonth > MaxPastMonths,
BLANK (),
CALCULATE (
SUMX (
FILTER (
ALLSELECTED ( 'Sales Data' ),
'Sales Data'[Months (as number)] <= CurrentMonth
&& 'Sales Data'[Months (as number)] <= MaxPastMonths
),
'Sales Data'[Revenue of product]
)
)
)

[v-pnaroju-msft]

Hi knut12212,

Kindly provide some sample data which explains your problem or question clearly in a simple and neat format, not as an image. This will help us to understand and solve the issue more effectively. Please ensure the data is relevant, does not have any sensitive details, and is connected to your problem. Also, let us know what result you expect from this sample.

Thank you.

[v-pnaroju-msft]

Hi knut12212,

Please share some sample data that shows your problem or question clearly in a simple and organized way (not as an image). This will help us understand and solve the issue better. Make sure the data is relevant, does not have any sensitive information, and is related to your problem. Also, please tell us what result you expect from this example.

Thank you.

[v-pnaroju-msft · Accepted solution]

Thankyou, @lbendlin, for your response.

Hi knut12212,

We appreciate your question on the Microsoft Fabric Community Forum.

We kindly request you to provide sample data that clearly demonstrates your issue or query in a structured format (not as an image) to help us understand and resolve the matter. Please ensure that the data is relevant, free from any sensitive information, and directly related to the issue. Additionally, please share the expected outcome based on the given example.

Thank you.

[lbendlin]

Looks like your data model is missing a calendar dimension table. Filters should be applied to dimension tables.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...