Forum Discussion
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...
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
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
I apologize. What should I do to improve the post? I can't post the whole table unfortunately but am happy to include more details.