Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Calculate Grand Total

Hello experts,   I would like to show the "Grand Total" of all these values on a pie chart  Here's the code for the line, the other one is the same but with 2022   I created this mea...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    Please make sure where is month columns from in your line visual. 

    Try measure as below.

    Mix CPNL 2021 =
SUMX ( VALUES ( 'TableName'[Month] ), [CPNL 2021] )

     

    Best Regards,
    Rico Zhou

     

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

 

Please make sure where is month columns from in your line visual. 

Try measure as below.

Mix CPNL 2021 =
SUMX ( VALUES ( 'TableName'[Month] ), [CPNL 2021] )

 

Best Regards,
Rico Zhou

 

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