Forum Discussion

2487jbml's avatar
2487jbml
Frequent Visitor
6 years ago
Solved

Grand Total Manipulation

Hi all, 

 

Is there a way to manipulate the grand total for a column?  I have multiple columns and the grand totals are all calculating correctly.  However, each departments goals have been slightly inflated but leadership would like for the grand total to be uninflated.  Is there a way to do that?  The goal data is stored in a table created in Power BI.  Here's an example: 

 

DepartmentGoalDesired Goal 
A1010 
B2020 
C3030 
D1010 
E2020 
Sum, but not desired overall goal->9070<- Hard number, not total of sums, but is the actual goal
Need Help
Tips and Tricks
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi 2487jbml ,

     

    Please create a measure like that to work on it.

    D =
VAR dr =
    CALCULATE ( SUM ( 'Table'[Goal] ) )
RETURN
    IF ( ISFILTERED ( 'Table'[Department] ), dr, 70 )

     

     

2 Replies