Forum Discussion
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.
1 Reply
- Greg_Deckler
Community Champion
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