Need the same value as the category for all rows below

[Earkkaperk]

Hi,

I want to have one field that having value 7920 for all rows below. Could you please help me on this?

The field 'calculated_LT' is in measure that I can't change anything.

Then I will sum up for C1 C2 C3 as a total of week.

Thank you

[Earkkaperk · Accepted solution]

Hi, I just got the solution from here Solved: Re: Get Total of category at subcategory level - Microsoft Fabric Community If anyone found the same problem as me

[v-nuoc-msft]

Hi @Earkkaperk 

Please provide some virtual data and the results you want. It is best presented in tabular form. Delete sensitive data.

Regards,

Nono Chen