Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
16 | |
10 | |
8 | |
8 | |
7 |