Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 13 | |
| 8 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 29 | |
| 19 | |
| 18 | |
| 11 | |
| 10 |