Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
HI, @Anonymous
After my test, you could try this way:
Step1:
Add a Month NO column for sales targets table, because Month column in sales targets table can't match with Month column in sales table.
Step2:
Change the cross filter direction to Both
Step3:
Use this formula to create a calculate column
Column = CALCULATE(SUM(Sales[ordval]),FILTER(Sales,Sales[Month]='Sales Targets'[Month NO]))+0
Best Regards,
Lin
Hey,
please create a pbix file that contains some sample data, and the reflects your data model, upload the file to ondrive or dropbox and share the link.
Regards,
Tom
Hi @TomMartens, this is my file https://www.dropbox.com/s/6d9phkxtrdnoz9p/Sales.pbix?dl=0
HI, @Anonymous
After my test, you could try this way:
Step1:
Add a Month NO column for sales targets table, because Month column in sales targets table can't match with Month column in sales table.
Step2:
Change the cross filter direction to Both
Step3:
Use this formula to create a calculate column
Column = CALCULATE(SUM(Sales[ordval]),FILTER(Sales,Sales[Month]='Sales Targets'[Month NO]))+0
Best Regards,
Lin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |