Forum Discussion
Inserting values from one table to another table based on the selection of slicers
Community SupportHi thbaero ,
Sorry for that but the calculated columns are computed during the database processing and then stored in the model. So In your scenario, we cannot make the calculated column dynamically.
We can create a measure and the relationship between tables to meet your requirement.
1. Create relationships between your tables,
2. Then create a simple measure like this,
BaseValue = CALCULATE(SUM(I_N_V_Values[BaseValue]))
3. And use I_N_V_Values[BaseDate], BurnUpCurve[BaseType] and [BaseValue] measure to create a table visual. We can get the result like this,
If it doesn’t meet your requirement, could you please show the exact expected result based on the table that we have shared?
BTW, pbix as attached.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @_ zhenbw
thank you for the quick reply. But currently I am in the middle of a huge "chaos" in my head.
Still trying to figure out the logic behind some of the DAX concepts (and going through the guided learning for that matter).
I already moved on a little bit on in my train of thoughts.
I will still need some time to really think about my problem in order to be able to describe it.
Enclosed you can also find a set of data I sampled and anonymized from the real data.
https://drive.google.com/open?id=1PNiHrgyjOQgh3J0KXhO7uVSERILLyo5M
Basically I am having a set of data from a database that is exported once a week (ExportDate)
The data is a list of elements which are categorized by
- Team (Team 1, Team 2, ...., )
- BaseName (I, N, V)
- ElementStatus (open, in progress, done)
For the BaseNames there is a second table that holds specifc dates for each distinct BaseName
| Base Name | Week |
| Start | 44/2019 |
| I | 51/2019 |
| N | 09/2020 |
| V | 22/2020 |
| End | 27/2020 |
(Actually those dates are the Mondays of each week but the picture below only shows the weeks)
I want to generate a combined stacked column and line chart from this data:
- The stacked column chart should show count of elements grouped by ElementStatus over time (ie ExportDates)
- The line graph should display the cumulative amount of elements on a specific ExportDate (selected by a slicer) matched to the specific date of the BaseName.
- I want to be able to select a team on a slicer and get the data for that team.
If I don't select a team than the cumulative Sums over all teams should be displayed.
Many thanks for the help!
Please be aware that I am currently using MS Power BI (September 2019) and apparently PBIX-Files from the current version are sometimes not compatible with my version.