Forum Discussion
Adding two metrics based on multiple criterion
How are these tables related and what are you expecting to have in your visuals? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hi Greg,
Thank you for sharing that link with me - it was a super helpful read.
I apologize for laying out my problem so ambiguously.
To answer your question, I'm trying to calculate the total revenue by sales rep by category.
My first table is the sales table which includes revenue by sales rep by category by account by date by etc etc..
My second table is a manual adjustment table (adjustments that we have had to make outside of the system generated report) which includes the manually adjusted revenue by sales rep by category. Not all reps have manual adjustments.
So my total revenue by sales rep by category = table 1[revenue by category]+ table 2[manually adjusted revenue by category].