Hi @Alf1507 ,
There is a way to calculate cumulative productions is to use the CALCULATE function with the FILTER function and the ALL function. For example, you can create a measure like this:
Cumulative Production =
CALCULATE (
SUM ( Table1[Production] ),
FILTER (
ALL ( Table1[Date] ),
Table1[Date] <= MAX ( Table1[Date] )
)
)
This measure will sum up the production values for all the dates that are less than or equal to the current date in the filter context.
To filter by another table’s column values, you need to have a relationship between the two tables. Then you can use the RELATED function or the USERELATIONSHIP function to access the values from the related table. For example, if you have a table called Table2 that has a column called Category, and you want to filter by Category = “A”, you can create a measure like this:
Cumulative Production by Category A =
CALCULATE (
[Cumulative Production],
Table1[Category] = RELATED ( Table2[Category] ),
Table2[Category] = "A"
)
This measure will use the existing relationship between Table1 and Table2 to filter by Category A.
Solved: How to filter in DAX using another column in a tab... - Microsoft Fabric Community
Solved: DAX help - filter another table based on value in ... - Microsoft Fabric Community
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
