Forum Discussion
How to store table list in mapping table
Hi All,
Suppose below is dax and want to store List { "Red", "Black" } in mapping table. Is it possible in power BI & how?
Thanks ,
Pooja Dhonde
hI Anonymous
You can't pass on values to a calculated table dynamically (eg via slicer selection). They update only upon modifying the formula, the reference tables have been modified or upon refreshing the underlying data. So when you create a calc table, you must consider adding all the possible needed values/combination to be used in other calculations.
4 Replies
- danextian
Super User
Hi Anonymous
What do you mean by want to store List { "Red", "Black" } in mapping table. Do you intend to append these values to an another table? What are the columns in that table? Please elaborate.
Hi danextian ,
Actually is calculated table and requairment is like need to pass dynamic values from mapping table :RedOrBlack Sales IN :=CALCULATE ([Sales Amount],Products[Color] IN { "Red", "Black" })
I am planning to store { "Red", "Black" } in mapping table wich is below
and want to pass it table dax.
Thanks ,
Pooja- danextian
hI Anonymous
You can't pass on values to a calculated table dynamically (eg via slicer selection). They update only upon modifying the formula, the reference tables have been modified or upon refreshing the underlying data. So when you create a calc table, you must consider adding all the possible needed values/combination to be used in other calculations.
- Daniel29195
Community Champion
Anonymous
you can store red , black in a table and then you can use in your dax : products[color] in tabl_name . if that what you want.
if not, please clarify your requirement so we can help you with your requirement.
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
