Forum Discussion

wl2020's avatar
wl2020
Frequent Visitor
6 years ago

Dynamically outut array items to filter calculate sum

So I have a tableN_Dim_Account_Value, and I am trying to create a slicer with a custom list of indicators that filters the values. To do that, I created a separate, unconnected table that look like this:

 

Then I created a measure to calculate the sum of the value based on the row IDs

 

CALCULATE(SUM(LN_Dim_Account_Value[value]); LN_Dim_Account_Value[UID] IN {[lnDimUID]})

 

The formula would output the correct value if there is only a single row ID in the list. If there is more than one item, however, it stops outputting results. But if I type the exact same items into the formula, (i.e. {"VHR_2464994"; "VHR_2464255"}), I get the desired result except the formula wouldn't be dynamic then...is there any way to output the array item dynamically in a way that will achieve the desired result?

 

Thanks in advance for your help.