Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dynamic Project Cost

Hi,   I'm trying to get the Project cost dynamically based on Month and Year. Below is the sample data.   Project ID Project Name Start Date End Date Monthly Cost 1 A 01-01-19 31-12...
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi Anonymous 

     

    Please change the relationship between fact table and employee table and set the cross filter direction is both.

    Result:

    Pbix in the end you can refer.

    Best Regards

    Community Support Team _ chenwu zhu

     

    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
4 years ago

Hi v-chenyue-msft ,

 

Thanks for the measure.
Although this is what I wanted, the measure doesn't work fine with the columns from other tables.
I have connected the Project table to an Employee table based on Project ID to get the employee details.

 

I would like to see the Project name, respective Employee email and the cost.
Sample below.

Could you kindly suggest on how can the measure work when a column from other tables are got in the table.

 

 

Thanks,

Regards.

 

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi Anonymous 

 

Please change the relationship between fact table and employee table and set the cross filter direction is both.

Result:

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

 

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