Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Calculated sum from another table

Hi everyone,   I am making a report in Power BI. I am trying to get used hours per area (Id); building; group(no). I have two tables. The way my data is formatted there are two tables, one (table a...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    Anonymous,

     

    You may use a similar way as shown here.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks, that helps a bit further.

 

UsedHours_Buildingblock = CALCULATE(SUM(AA_RV_KPI_HOURS_6106[USED_HOURS]);FILTER(AA_RV_KPI_HOURS_6106;AA_RV_KPI_HOURS_6106[Building]=MAX(ReportResult09[Building])&&AA_RV_KPI_HOURS_6106[Discip]=MAX(ReportResult09[Discip])))

 

However, the table is not showing expected total sum as shown below. Feedback will be appriciated, thanks, rgds H

 

v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

Anonymous,

 

You may use a similar way as shown here.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thank you, v-chuncz-msft!

     

    Rgds

    Henrik