Forum Discussion
Making row value equal to Column Name
Hi, I can't figure out how to solve this dax problem of mine. I have searched the forum but could not find an answer. Given tables like this which are related one to Many (from left to right): ...
I would suggest restructuring your reference table like this:
| Name | Code | Value |
| John | 0191 | 2 |
| Mark | 0191 | 5 |
And so forth. You can do this easily in the Power Query editor. (lookup how to pivot/unpivot tables)
Then you could write a formula like this:
Measure =
VAR code = SELECTEDVALUE(Sales[code])
VAR name = SELECTEDVALUE(Sales[name])
RETURN
CALCULATE(
SUM(Table1[Value]),
Table1[code] = code && Table1[name] = name)
* Sales[Sales]
Thanks for the reply cstaulbee.
Unfortunately, the values in Table 1 from columns '0191', '5191', and '4221' are calculated columns. If I'm not mistake, I can only pivot tables from the original data source correct? If this is true, how should I go about solving this problem?
You could create calculated columns like the 2 that I gave as an example. I'm not sure what the data looks like that you're building the calculated columns off of so it's hard to say how you could do that.