A finished product goes through a series of process to be made. I would like to establish a data model to validate if a product SN met the criteria for each process with the standards stated on the table on the right. Some of the criteria require the value to meet a specific nomenclature, with string containing certain text value. (e.g. 100 Feature 5).
Table on the left is a fact table. Seeking ideas how to create an efficient data model or mapping design along with the recommended DAX measure or column.
Hi @llchoong - Based on the Screenshots, can create relationship b/w Fact and process table by creating a new Column i.e. concatenation/combination of Process and Feature column as it will make it unique.
Regarding the second issue, can’t have a generic statement like “at least 100”, “has this nomenclature XXX” etc. Need to have values for min and Max like
Min Max
100 1000000000
XXX XXX
0 91
Once done, then can create DAX using IF else condition to handle numeric/String scenarios.
If need further help with DAX, please share the data in an excel format.
