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 a...
Need Help
Show and Tell
Tips and Tricks
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    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 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 months ago

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
Helper II
6 months ago

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!

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    6 months ago

    Sorry but just not clear about what youw want.