topic CALCULATETABLE VALUES with more than one filter in DAX Commands and Tips

CALCULATETABLE VALUES with more than one filter

F75 — Thu, 23 Feb 2017 06:19:15 GMT

I have two tables 'Data' and 'Input'. I am tryng to lookup value for Account and Scenario in 'Data' table from 'Input' tables. In 'Input' table scenario is arranged in columns. How can i use a lookup function to retrive data based on row values from table 'Data'?

e..g Row 5

2017 Plan A | Sales | .........| 1010 (New Unit Price)

Data

Input

Re: CALCULATETABLE VALUES with more than one filter

technolog — Tue, 12 Sep 2023 10:23:38 GMT

Can you please tell me if the problem is still relevant? If you managed to solve it in some way, please write here how you solved this problem. Then it will be possible to mark this problem as solved.

If not, it may make sense to ask the question again, thus confirming the relevance of this problem.