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 ,

 

You can still calculate it in a measure. I did similar many times:

new planned points = 
VAR __CurrentRowMonth = MAX('Date'[Month])
VAR __CurrentRowPlant = MAX('...'[plant])
VAR __TempTable = SUMMARIZE('database-pbi','Date'[Month],'...'[plant],"planned points",[points per hour]*[planned pours])
VAR __TempTable2 = FILTER(__TempTable,[Month] = __CurrentRowMonth, [plant] = __CurrentRowPlant)

RETURN
    SUMX(__TempTable2, [planned points])

Just correct table names in quotes.


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

Thanks amitchandak  and zoloturu 

 

I am getting blanks in the created column [planned points] and I think it is becuase the way the table is set-up. Below you will see that I a values column and a category column. It makes sense that when I just try to multiple the two created columns ([planned pours] and [points per pour]) I get a blank for my result ([planned points]). Any other thoughts here? It's like I need to place filters on the sum statements so that it is multiplying [month]&[job_id] of [planned pours] and [month]&[job_id] of [points per pour].... I think that can only be done in a measure though.

 

  • zoloturu's avatar
    zoloturu
    Memorable Member
    6 years ago

    jyeager ,

     

    Did you tried a measure which I advised you earlier? (Don't create it as a column, it should be a measure).


    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