Forum Discussion

dom-mitchell's avatar
dom-mitchell
Frequent Visitor
3 years ago

Pulling a Measure into a Table based on Filters

Hi there, this one has me stumped... What I am looking to achieve is a calculated column ( [Invoiced] ) in a table ( 'MonthNumber' ) that shows the value from a measure ( 'Invoiced Deal Data'[Tota...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

dom-mitchell , Columns are static, so using measure or expectation is that they will filter based on selection will not hold.

 

If there is a join, the measure do not need that relationship in filter again

 

to create a column in the table using another table

refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

 

not use what you want achieve using match by