Identify New Business DAX

Hi,

I do not understand the problem.  Please be specific where the problem is and also show me your expected result.

Hi,

I am wanting to create a summarized table showing 

Number of New Business    Number of interactions    Revenue

Then a table showing

Number of Business That spent this Year and Last Year    Number of interactions    Revenue

and

Number of Lost Businesses    Number of interactions    Revenue

using the title slicer and month slicer.

Thanks 

With the true company and new business in the same table it says new business is 166, however if you remove the true company field it says there are  1003

Something like

Table 6 = SUMMARIZE(Query1,Query1[TrueCompany],"New Business",CALCULATE(COUNTROWS(Query1),FILTER(VALUES(Query1[TrueCompany]),[Date of first interaction with Company]>=MIN('Calendar$'[Date])),Query1[ttlname] = "Barrow Advertiser"),"Number of Weeks",CALCULATE(DISTINCTCOUNT(Query1[FinWeek of Year]),FILTER(VALUES(Query1[TrueCompany]),[Date of first interaction with Company]>=MIN('Calendar$'[Date])),Query1[ttlname] = "Barrow Advertiser"))