Having trouble with DAX formula

[Joseph_Hchaime]

Hi,

I need to translate a formula into a dax measure. 

The formula is: # new clients opened and billed this period/ total # of clients billed in the same period (not only new)

My data has a clients table with unique IDs per client, a created date for the client as well as a bills table with unique IDs per bill and the bill issue date. 

I tried using CALCULATE (COUNT(Clients_ID)),Client_Creation_Date = Year (Today)),Bill_Issue_Date = Year (Today)) - For the New Clients portion of the formula (Numerator). 

but it isn't working. 

Can someone help? it's time sensitive. 

[Joseph_Hchaime]

Yes exactly. No issue with the relationship. It's the dax syntax that i'm having trouble with. 

[Joseph_Hchaime]

Yes exactly. No issue with the relationship. It's the dax syntax that i'm having trouble with. 

[Ale]

How is the relationship between these 2 tables (Client and Bills)? Do you have Client ID in your Bills table to join them?

[Ale]

Can you then double check your DAX? The way you pasted here you are closing the CALCULATE bracket right after the COUNT, so the formula will not work as it ignores everything that comes after it.

CALCULATE (COUNT(Clients_ID)),Client_Creation_Date = Year (Today)),Bill_Issue_Date = Year (Today))

Try to remove that bracket (in red) and see if the formula works.

[Joseph_Hchaime]

I got this error

[Ale]

You must use Today() and not only Today.

Year(Today())

[Joseph_Hchaime]

I noticed that and I corrected it after posting my reply. The thing is I'm getting blank as a result. Whereby I'm positive we've billed new clients this year 

[Ale · Accepted solution]

It could be because you are comparing a full Date with a Year.

Try adding YEAR() to all the dates.

Year(Client_Creation_Date) = Year (Today())

Year(Bill_Issue_Date) = Year (Today())