Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Error in measures between two linked tables

Hello. I have two tables. Table_1 is for scheduled work that contains an employee ID, work area number, cost center number, the date, and the amount of scheduled hours (along with others that are irr...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous 

I make a test as below, could you have a try like me?

Measure = SUM('1'[hour planned])

Measure 2 = SUM('2'[hour worked])

Measure 3 = [Measure]/[Measure 2]

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
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

    v-juanli-msft  Thanks for the response. The measures that you have provided work, but when I attempt to filter both measures by cost center, then that is when I get an error. My question then becomes how I can create a link between each cost center such that filtering works on both measures.

    • v-juanli-msft's avatar
      v-juanli-msft
      Icon for Community Support rankCommunity Support
      7 years ago

      Hi Anonymous 

      I can't reproduce your problem.

      Could you provide a simple test file, then upload to one drive  and share me the link?

       

      Best Regards
      Maggie

       

      Community Support Team _ Maggie Li
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.