Need help in defining a measure

[abhi8569]

Hello All,

I have a data model which looks something like this:

My requirement is to count the number of Invoice Number that satisfies following logical expression:
InvoiceDate(InvoiceMonth) == BillingDate(Billing Month) && InvoiceDate(InvoiceYear) == BillingDate(Billing Year)

I am not sure if that's even possible given how data is modelled. Kindly help me out in writing a DAX measure.

The Billing Date table contains three billing dates corresponding to previous, current and Next Billing date for each customer. Invoice Detail table contains informatrion of all the invoices generated for the customers.

Thank you!

[RMDNA]

Hi @abhi8569 - the way you've drawn it, is the relationship between Customer Detail and Billing Date going in the wrong direction? I would imagine BillingDate is a date table with unique dates, so the 1: should be on that side.