Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Table not reflecting changes in new data from another table

Hi. I currently have an issue whereby one table linked through an active relationship (Many to One, single filtered), isnt reflecting any new data input from the source table.   I have the source t...
Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

      

    Hi Anonymous ,

     

    Enter into Query Editor, click on all Day# column such as Day#15 -Day#17 at the same time, then choose "Unpivot Columns", rename this result column "Attribute" with "Day#" . Don't forget to click the "Close & Apply" button.

     

    Then you can create measure like DAX below to get sum value for per Resource# and per Day# .

     

    Measure1= CALCULATE(SUM(Table1[Value]),FILTER(ALLSELECTED(Table1),Table1[Resource#] =MAX(Table1[Resource#])&&Table1[Day#] =MAX(Table1[Day#])))

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
7 years ago

  

Hi Anonymous ,

 

Enter into Query Editor, click on all Day# column such as Day#15 -Day#17 at the same time, then choose "Unpivot Columns", rename this result column "Attribute" with "Day#" . Don't forget to click the "Close & Apply" button.

 

Then you can create measure like DAX below to get sum value for per Resource# and per Day# .

 

Measure1= CALCULATE(SUM(Table1[Value]),FILTER(ALLSELECTED(Table1),Table1[Resource#] =MAX(Table1[Resource#])&&Table1[Day#] =MAX(Table1[Day#])))

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thank you Amy, this worked perfectly :)