Need help on creating custom row grand total in power BI desktop

[Krishnanidar]

Hi Team,

Pls help on creating custom row grand total in power BI desktop. Breaking my head for the entire day

Thanks in advance

[v-yangliu-msft · Accepted solution]

Hi  @Krishnanidar ,

Are you referring to the difference between measure and sum of value?

This is because I am customizing the rule, The Total row shows the synthesis of month 3 or less than or equal

If you want Masure's Total row to display the total value, you can use the following formula:

Measure =
IF(
    ISINSCOPE('Table'[Date]),MAX('Table'[Value]),
    SUMX(ALL('Table'),[Value])
        )

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Krishnanidar]

@v-yangliu-msft 

Thanks in advance

[v-yangliu-msft]

Hi  @Krishnanidar ,

I created some data:

You mean whether you want to customize the Total row of the table Visual, you can use the IF() and Isinscope() functions to determine whether it is a Total row

IF function (DAX) - DAX | Microsoft Learn

ISINSCOPE function (DAX) - DAX | Microsoft Learn

Custom rules:

The Total row shows the synthesis of month 3 or less than or equal

Here are the steps you can follow：

1. Create measure.

Measure =
IF(
    ISINSCOPE('Table'[Date]),MAX('Table'[Value]),
    SUMX(
        FILTER(ALL('Table'),MONTH('Table'[Date]) <=3),[Value])
        )

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Krishnanidar]

Hi @v-yangliu-msft 

But when i am dragging in matrix as below showing different values.