Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Sales performance tracker

Hi everybody,  I have the following challenge.   The following table is available to me for our sales submit. Submitted Date Name Designation Region Status 10/10/2021 ABC Jr. Corp Sal...
Need Help
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Join the second Table with first Table  and also join first table with date table and have month year column

    Target Score=

    Sumx(Table1, related(Table2[Target])

     

    Variance = Countrows(Filter(Table1[Status] = "Approved")) - [Target Score]

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

Create a relationship between two tables by using column [name].

Then create a measure as below:

 

Measure = 
var c_approved = CALCULATE(COUNT(sales[Status]),FILTER(sales,sales[Status]="Approved"))
return
c_approved-SELECTEDVALUE(Target[Target])

 

 

Best Regards,

Jay