Forum Discussion
Calculating DATA from different Tables
Hello Power BI Gurus,
I am not sure how to even ask this question with my limited knowledge of the program but i am going to do my best.
I have a table i am pulling 8 sources from different tables to come up with the data needed to be displayed. ( As shown below)
All these sources share a relationship and i am filtering on that relationship (PHASE).
My question is i need to do a caluction with the data shown in the table above with another table shown below,
Ideally coming up with something like this
SO in theory DISCPLINE*WEIGHT OF SYSTEM=WEIGHTED DISCPLINE
APPERCIATE ANY HELP ANYONE CAN PROVIDE!
6 Replies
Hi Anonymous
create a table that only contains the discpline names (discpline_dim). Please make sure that the discplines are spelled exactly the same in every table. After that, in your data model you can connect the Weight Table and the % Discpline Table over the discpline_dim table like that:
With the following measure you can calculate the weighted discpline:
Weighted_Discipline = SUM('Weight'[Weight of System]) * SUM('%Discipline'[% Discipline])
Putting everything in a table gives you this result:
Thank You Anonymous this solved a portion of my issue. The only part that i dont know how to fix is the 8 measures. How do i get the 8 measures from multiple tables into 1 table to compute the way you have it written out? I am sure there was a cleaner way to do what i did but i have limited knowledge.
if this is possible then its smooth sailing.
Thank you again for helping!