Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Using Value from a Filtered Table

Another question.   I have a table called t_Fruit with one column named Fruit_Name.  The table contains 3 rows, Apples, Pears and Bananas.   I have added a slicer which is based on t_Fruit[Fruit_...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

The only part of the data model that is created on the fly is within measures.  If you are doing a SELECTCOLUMNS within a calculated table, then that table is only populated when the model is refreshed.  This is not truly dynamic as all the tables within your model have to be refreshed for the calculated table to be refreshed. 


It sounds like maybe you don't have your relationships set up correctly in your model - can you confirm if you have a relationship between your product table and your shopping table? 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

To help explain what I am trying to do I have created a very simplified version, the link is below.

 

If you look at the defintion for t_Shopping, I am trying to set the value for the second column in this table to be equal to the type of fruit selected from the filter shown.

 

Hope this makes it clear.

 

Thanks.

 

https://drive.google.com/open?id=1c2NvjYoGi8oG8L5IEBy9KbaQVrBkZHTm

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi, 

    still not quite sure why you are doing this, are you trying to analyse fruit sales? 

    If so you need to think about a suitable data structure to do that, currently you have 3 separate tables and no relationship between them.  

    Power BI is an application for anlaysing data, not creating shopping lists, unless you are perhaps doing basket analysis?