Using Dates Not in a Date Table to Calculate Open Accounts Receivable

[Melissa]

Hi @ScottTPA,

I’m guessing you have an active relationship between your Dates and Invoices table.
That will result in a single row being returned by the Dates table. If there are only inactive relationships both AR[invoice date] and AR[Paid Date] will be considered equal and your measure should work.

Having only inactive relationships means that in other measures you’ll have to “activate” one of the exsisting relationships with the function USERELATIONSHIP inside of CALCULATE.

Some other references can be found here.

Counts number of Incidents with a Date slicer

Hello @supergallagher25, Thank you for posting your query onto the Forum. Just for the reference I’ve changed the relationship in your file which was one-to-one and bi-directional to One-to-Many and single directional as per the fundamentals. Below is the screenshot attached for the reference. [Count no. of incidents - 1] Now, for calculation purpose you can use the formula as shown below since you’ve an inactive relationship. You can turn on this inactive relationship by using the USERELAT…

https://forum.enterprisedna.co/t/how-does-userelationship-compare/4939

https://forum.enterprisedna.co/t/comparing-treatas-vs-userelationship-in-power-bi/11562

I hope this is helpful