Im using a matrix to see the weight of produced products for a week. In the table i have created a colunt that shows if the line are in the current week or not. If in the current week, the field value is “Ja”.
The columns is the weekdays using name of weekday from date table. In the example, “mandag” (Norwegian) eq to “Monday”.
The values is a calculated field:
Sum vekt produsert denne uke = Calculate([Sum vekt tonn],Filter(‘Data elementer’,‘Data elementer’[ProdDenneUke]=“Ja”))
For tuesday-friday, for the actual week (week 38) there is not produced any products, but i like to show every day in the matrix, and with 0 in the day that with now production.
The calculated value works well, but im missing the rest of the day in the week. Any idea how to add this to the matrix ?