Forum Discussion
Draszor
Helper III
Helper IIILookup values from another table while keeping the visual filter context
Dear All, I have 3 tables: FINANCIALS - table containing transactional data for projects (the same project repeats many times, ther are dates for the transaction etc) PROJECT_NAME - table conta...
Hi Paul Zheng,
I was trying few solutions. when I linked PROJECT_BUDGET table to FINANCIALS (or linked it to PROJECT NAME, that was linked to FINANCIALS) then in certain scenarios I was getting desired results, however all projects from PROJECT_BUDGET were expanded in the visual.
My ned was to get only those projects that have financials, so only those that are present in FINANCIAL table. this works fine with keeping the tables not linked and using Selectedvalue.
DraszorHelper III
Helper IIIDear Colleagues,
I needed the solution urgently and worked it out (I think).
The following formula makes its work:
Project Budget =
calculate(
[AMOUNT BUDGET], //this is the amount from the PROJECT_BUDGET table
filter(all('Project Budget'),'Project Budget'[Project Number] = SELECTEDVALUE(FINANCIALS[Project Number])
)
)
BR
BR