Forum Discussion

wl2020's avatar
wl2020
Frequent Visitor
6 years ago
Solved

Filter using values in a table

    So I created a table to filter the calculate results. The table looks like this:     CALCULATE(SUM(LN_Dim_Account_Value[value]); LN_Dim_Account_Value[UID] IN {[lnDimUID]})   The idea...
  • Anonymous's avatar
    Anonymous
    6 years ago
    Hi.

    You should never store non-atomic entities in one field. If you have the above situation, you have to create a mapping (a bridge table) between your records and all the ID's that are present in your string for that record. You have a Many-2-Many situation here.

    Best
    D