Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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:

 

Table Example 

 

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,

 

 

 

6 Replies

  • 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 

  • Hi Anonymous 

    I don't have access to that link.  Google won't let me in.

    regards

    Phil

  • 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's avatar
      Ashish_Mathur
      Icon for Super User rankSuper 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's avatar
        PHEstaciMa1
        Icon for Helper II rankHelper 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!