Forum Discussion
Sum Two Measures from Different Tables
Greetings to all,
A little context before posting my question:
Monthly, I evaluate the results meetings in the place where I work. In this meeting, indicators that deviated during the month are presented. I give a score (1, 3, 5) for the analysis of the indicator and also for the countermeasure.
I have two tables as the attached file:
In table 1 it is possible to find the table that I use to annotate the score of the analyzes and countermeasures.
For area A1, in March, 4 indicators had deviations. The maximum score that A1 could have in the month would be 40, but according to my evaluation, it was 32 (80%). However, this value represents only 20% of the final score, that is, the score will be 16%. I managed to reach that value using some measures.
In table 2 I note if the meeting of the month took place.
Basically, if the meeting took place, the Area makes 15% of the score. For this, I created a Calculated Column using IF.
In March A1 held the meeting, then + 15% for the score.
Here is my question:
I need to sum these two values (16% + 15%). However, when I sum the two measures, the result is 46%.
Any ideas how to solve?
Best Regards,
Hi,
I am not sure how you could get the result of 46%, but I might assume that the Month-Filter did not apply to Table_2. So, the calculation might be 16% + 15%(Table_2_March) + 15%(Table_2_April). Please correct me if I wrongly understood.
The below picture is what I have done. Please check.
I also wrote pbix file link down below. You can see all measures in the file.https://drive.google.com/file/d/18lmRMdqE1MfTLOjf-qwI5U2BXTOvhxgW/view?usp=sharing
6 Replies
- Jihwan_Kim
Super User
Hi,
I am not sure how you could get the result of 46%, but I might assume that the Month-Filter did not apply to Table_2. So, the calculation might be 16% + 15%(Table_2_March) + 15%(Table_2_April). Please correct me if I wrongly understood.
The below picture is what I have done. Please check.
I also wrote pbix file link down below. You can see all measures in the file.https://drive.google.com/file/d/18lmRMdqE1MfTLOjf-qwI5U2BXTOvhxgW/view?usp=sharing
- PhilipTreacy
Super User
Hi Anonymous
I don't have access to that link. Google won't let me in.
regards
Phil
- PHEstaciMa1
Helper II
Hi, I do have similar question here. Jihwan_Kim Ashish_Mathur
HELP NEEDED: I need the sum of the total counts of coaching conducted by a particular person from two different tables with different formatting or presentation of data (see excel sample database source), several tables were created for relationship purposes which includes name, email, department, etc. (see screenshot relationship).
https://drive.google.com/drive/folders/1IKSTNLXTHE_Iw9Z7XSq4Yr3J1lgvuIYS?usp=sharing
- Ashish_Mathur
Super User
Hi,
Cannot understand what you want. Share the download link of the PBI file with relationships built and measures written. Show the problem there and the expected result.
- PHEstaciMa1
Helper II
Ashish_Mathur unfortunately I can't share the pbix file as it contains personal identifiable information which violates possible privacy data. I have attached a sample database in the google drive, now, the other tables were create from the same table I shared to ensure consistency in the dept, name, email etc. Thanks!