Count Help: How many people achieved their target

[Anonymous]

Will try my best to explain what im looking for

So i have a table which has all the information. What im looking for is first to count the number of sold for each employee. 

CALCULATE(COUNTROWS(FILTER(Table1,Table1[Status] = "Sold")

I then have another table that has the target for each employee. 

This is what im trying to achieve in the end. A card that tells you how many employees achieved their target for the month selected in the filter at the top of the page. 

In our case the month selected is July and B & C are the two employees who achieved their target thus the 2 in the card

Any help appreciated

Thank you

[tamerj1 · Accepted solution]

Hi @Anonymous 
Here is a sample file with the solution https://we.tl/t-4kHt3LpgmZ

Target Achieved = 
VAR T1 =
    ADDCOLUMNS (
        CROSSJOIN ( VALUES ( Names[Name] ), VALUES ( 'Date'[Month-Year] ) ),
        "@CountSold", COUNTROWS ( CALCULATETABLE ( Table1, Table1[Status] = "Sold" ) ),
        "@Target", CALCULATE ( SELECTEDVALUE ( Table2[Target] ) )
    )
VAR T2 =
    FILTER ( T1, [@CountSold] >= [@Target] )
RETURN
    COUNTROWS ( T2 )

Please feel free to let me know if you have any question

[amitchandak]

@Anonymous , Create a common table like date( using month year column , create date) and name.

and then you can create a measure like

Sold 1= CALCULATE(COUNTROWS(FILTER(Table1,Table1[Status] = "Sold")

Traget 1 = CALCULATE(sum(Table2[Target]))

Countx(filter(Name[Name]), [Sold 1] >= [Target 1] ), [Name])

refer

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda

[Anonymous]

Hi Amit, 

Thank you for your response. I have a measure for Sold and Target just like the dax measure you mentioned in your answer. Can you explain a bit more about the common table? 

What columns should i have in the common table?