trying to find a measure to calculate Grand total of another measure

[michaelag]

Hi

I need some help to try find a measure that can summarize my Hours (another measure) as per below, I have a column with Hours but cannot get a measure to Total Those hours 😞

Thank you

[v-yueyunzh-msft · Accepted solution]

Hi , @michaelag 

According to your description, you want to find a measure to calculate Grand total of another measure.

Here are the steps you can refer to :
(1)This is my test data :

(2)I create  a measure like you :

Hours Measure = SUM('Table'[Hours])

(3)Then we can create another measure , in the summarize() funtion, you need to update the dimension according to the fields you put on the visual:

Total = var _t =ADDCOLUMNS( SUMMARIZE(ALLSELECTED('Table'),'Table'[Category],'Table'[Salary],'Table'[Sub-category]) , "Hours Measure" , [Hours Measure])
return
SUMX(_t , [Hours Measure])

(4)Then we can meet your need, the result is as follows:

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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

[michaelag]

Hi Aniya

the problem I have is that the Hours is already a measure not something that lives in a table so I can't quite aggreagate that way. 

[v-yueyunzh-msft]

Hi , @michaelag 

Yes, in my test.pbix file , i create the [Hours Measure] as the [Hours] measure like you.You can dowxload it and see ~

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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