Forum Discussion
Missing reocrds
Hi all,
i want to calucalate the measure for missing records .
i have two tables
1. source Fact_9R_CIS_Monthly_Unit_Shipments_Report_PPS (ManfucturingID)
2. Target Vw_fact_AIS_9R_SPECIFIC_SHIPMENT_REPORt (SKU)
i want to show a table by region with missing distinct SKU's from source table for current month only.
how to create a measure for this?
3 Replies
Hi Anonymous
Can you please show a sample of both your tables and an example based on that sample that shows the expected result? It is not quite clear as you have explained it
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Anonymous , I recently created a file the to get the data from one table which not there in another table
https://www.dropbox.com/s/3wr697b3m57zufo/ExceptOther%20Tabl.pbix?dl=0
Check for Measure and Measure2
One more 3 tables https://www.dropbox.com/s/8lc85jz66i37j2z/except.pbix?dl=0
hi Anonymous
EXCEPT Function could meet your requirement, you could use it in the measure conditional.Regards,
Lin
