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
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

amitchandak's avatar
amitchandak
Super User
6 years ago

First create two columns in table

table column 1 = if(datbase-pbi'[category]="planned pours" ,'database-pbi'[value]),blank)

table column 2= if(datbase-pbi'[category]="points per pour" ,'database-pbi'[value]),blank)

 

You can multiple in 3rd column or use sumx.