Forum Discussion
Helper IVIssues in defining a measure
Dear All,
I'm struggling to define a measure and hope you can help me get through this.
I have 3 tables:
1) one category dim table
2) one fact sales table
c) one extra fact sales table
I want the OTH category to sumx the "copies sold (€)" related to the title "X" in the extra fact sales table. In a few words, my desired result is the following viz:
| Title | Copies sold (€) |
| Toki | 3954 |
| Ooops Up! | 356 |
| Jaguar XJ220 | 1711 |
| R Type | 2617 |
| IK+ | 1265 |
| OTH | 3200 |
Any idea on how I can come to this result?
Thank you a lot for your support!
gianmarco , Add a new row to first table (Category )
Create a new table using enter data, with column name Title and one-row value
OTH
Append this with first table
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Also, create a new column in table three with static value OTH and join with first table
New Title = "OTH"
4 Replies
- amitchandak
Super User
gianmarco , How this Title (X,Y,Z) are related with Category (Toki , OTH, IK+ etc)
gianmarcoIn fact, there is no relation.
What I need is a category named "OTH", which has nothing to do with the original fact sales table, and instead relates to only title "X" in the extra fact sales table (Title "Y" and "Z" in the extra fact sales table aren't take into consideration).- amitchandak
gianmarco , Add a new row to first table (Category )
Create a new table using enter data, with column name Title and one-row value
OTH
Append this with first table
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Also, create a new column in table three with static value OTH and join with first table
New Title = "OTH"