topic Re: Need the same value as the category for all rows below in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-the-same-value-as-the-category-for-all-rows-below/m-p/4025899#M158957 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="738323" data-lia-user-login="Earkkaperk" class="lia-mention lia-mention-user">Earkkaperk</a>&nbsp;</P> <P>&nbsp;</P> <P>Please provide some virtual data and the results you want. It is best presented in tabular form. Delete sensitive data.</P> <P>&nbsp;</P> <P>Regards,</P> <P>Nono Chen</P> Fri, 05 Jul 2024 01:26:15 GMT Anonymous 2024-07-05T01:26:15Z Need the same value as the category for all rows below https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-the-same-value-as-the-category-for-all-rows-below/m-p/4025464#M158909 <P>Hi,</P><P>&nbsp;</P><P>I want to have one field that having value 7920 for all rows below. Could you please help me on this?</P><P>The field 'calculated_LT' is in measure that I can't change anything.</P><P>Then I will sum up for C1 C2 C3 as a total of week.</P><P><img /></P><P>&nbsp;</P><P>Thank you</P> Thu, 04 Jul 2024 16:05:26 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-the-same-value-as-the-category-for-all-rows-below/m-p/4025464#M158909 Earkkaperk 2024-07-04T16:05:26Z Re: Need the same value as the category for all rows below https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-the-same-value-as-the-category-for-all-rows-below/m-p/4025899#M158957 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="738323" data-lia-user-login="Earkkaperk" class="lia-mention lia-mention-user">Earkkaperk</a>&nbsp;</P> <P>&nbsp;</P> <P>Please provide some virtual data and the results you want. It is best presented in tabular form. Delete sensitive data.</P> <P>&nbsp;</P> <P>Regards,</P> <P>Nono Chen</P> Fri, 05 Jul 2024 01:26:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-the-same-value-as-the-category-for-all-rows-below/m-p/4025899#M158957 Anonymous 2024-07-05T01:26:15Z Re: Need the same value as the category for all rows below https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-the-same-value-as-the-category-for-all-rows-below/m-p/4025966#M158962 <P>Hi, I just got the solution from here&nbsp;<A href="https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-Total-of-category-at-subcategory-level/m-p/3188941#M115591" target="_blank">Solved: Re: Get Total of category at subcategory level - Microsoft Fabric Community</A>&nbsp;If anyone found the same problem as me</P> Fri, 05 Jul 2024 02:17:58 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-the-same-value-as-the-category-for-all-rows-below/m-p/4025966#M158962 Earkkaperk 2024-07-05T02:17:58Z