Hi,
my problem is that a measure is not working as I am combining information from two tables, where the fact that for some records one table does not have any entries, I can not find a way to properly account for these non-existent rows in my measure (which would be to assign a 0 for these cases).
I want to construct a measure, where two variables from different tables are subtracted from another, with both tables having the same ID variable.
My variables are: Table1[Sales] and Table2[Cancellations]
I want to calculate the difference (Sales-Cancellations) by ID, to extract whether the value is larger than 0.
However, I do not have all IDs in Table2, since not all IDs are having Cancellations.
When I now compute:
To report on things that are not there you need to use disconnected tables and/or crossjoins
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!