My data is a list of table names, field names, key field names
I have a table, and a measure that works as a logical AND filter.
If a user selects 2 Key Field values, they will see only tables that have BOTH of those fields.
=Sum({<TABNAME = {"=COUNT(KEYFIELDNAME)=$(vKeyFieldsAvailable)"} >} 1)
I can also do this; the same, but for the 'field' column as opposed to the 'keyfield' column.
=Sum({<TABNAME = {"=COUNT(FIELDNAME)=$(vFieldsAvailable)"} >} 1)
Problem is when I want to use both if these filters together.
I tried this below, but it just results in an error - at least just displays null values.
=Sum({
<TABNAME = {"=COUNT(KEYFIELDNAME)=$(vKeyFieldsAvailable)"} >
,<TABNAME = {"=COUNT(FIELDNAME)=$(vFieldsAvailable)"} >
} 1)
I'm not that confident in the mechanics behind this, so hoping someone can help educate me as to where I'm going wrong !?
Thanks
