Forum Discussion
Sum Two Measures from Different Tables
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
Helper IIHi, 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
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
Sorry but just not clear about what youw want.
