Forum Discussion

jyeager's avatar
jyeager
Helper I
6 years ago

Help Needed! Data Aggregation / Summing Two Measures

Hello All! I am having some trouble with a measure I've named "planned points". The measure is simply multiplying [points per pour] and [planned pours]. It actually works as written. In "Screenshot 1...
Need Help
zoloturu's avatar
zoloturu
Memorable Member
6 years ago

Hi jyeager ,

 

If job_id is a grain of data then you can simply use SUMX:

 

= SUMX( 'YourTable', [points per hour] * [planned hours])

 
Regards,
Ruslan Zolotukhin (zoloturu)
BI Engineer at Akvelon Inc. / Kharkiv Power BI User Group Leader / DAX & Power BI Trainer
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
It was useful? Press Thumbs Up!

You are from Ukraine? If yes then welcome to Power BI User Group - KhPUG website. Other country? Check and find proper one - Power BI User Groups

jyeager's avatar
jyeager
Helper I
6 years ago

Hi zoloturu 

 

Thanks for the quick response! SUMX did not work. Its worth noting that the [points per pour] and [planned pours] fields are measure themselves:

  • [points per pour] = CALCULATE(SUM('database-pbi'[value]),'datbase-pbi'[category]="points per pour")
  • [planned pours] = CALCULATE(SUM('database-pbi'[value]),'datbase-pbi'[category]="planned pours")

 

Here is the result when I tried SUMX (measure was titled "NEW planned points":

 

 

 

 

Any other thoughts/suggestions? Thanks again!

 

JY