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 is that the user will click on a dropdown menu in a slicer, and then the formula calculates the sum of the value column based on the column IDs I provide in the table. The formula works for all items with a single column ID, but when there are more than one (the one separated by ";"), the formula stops working. 

 

Any idea how to make the formula work for cells with more than one value?

 

  • 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

3 Replies