Forum Discussion

ak77's avatar
ak77
Post Patron
1 year ago
Solved

Display Custom Total Value

Hi All  , need help on the below Please The below table is a summarized table.. and Total  values are sum/ average of the respective columns.. my client has asked if we alter the Values in Total For...
Need Help
Show and Tell
Tips and Tricks
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    Hi ak77 - you can create custom measures that apply different calculations for the total row versus the individual rows.

    create a custom measure for % Planned

     

    % Planned Custom =
    IF(
    HASONEVALUE(FactTable[Title]),
    DIVIDE(SUM(FactTable[Planned]), SUM(FactTable[Total])),
    DIVIDE(SUM(FactTable[Complete]) + SUM(FactTable[In Progress]), SUM(FactTable[Total]))
    )

     

    Replace the % Planned column in your table visual with the % Planned Custom measure you created.

     

    limitations like you must manually adjust each measure where the total-row calculation differs.It may not support every kind of complex aggregation, but it handles custom totals effectively for cases like this.

     

    Hope this helps.

     

rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

Hi ak77 - you can create custom measures that apply different calculations for the total row versus the individual rows.

create a custom measure for % Planned

 

% Planned Custom =
IF(
HASONEVALUE(FactTable[Title]),
DIVIDE(SUM(FactTable[Planned]), SUM(FactTable[Total])),
DIVIDE(SUM(FactTable[Complete]) + SUM(FactTable[In Progress]), SUM(FactTable[Total]))
)

 

Replace the % Planned column in your table visual with the % Planned Custom measure you created.

 

limitations like you must manually adjust each measure where the total-row calculation differs.It may not support every kind of complex aggregation, but it handles custom totals effectively for cases like this.

 

Hope this helps.