Forum Discussion

Emmy66's avatar
Emmy66
Icon for Helper V rankHelper V
5 years ago

Userelationship returns blank

Hi, Your assistance on this will be appreciated. Below is the SQL I am trying to replicate in DAX. SELECT Count(pg.ProgressId) FROM Progress pg INNER JOIN Project__ToProgress ptp ON ptp.progres...
Need Help
v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, Emmy66 

 

You have a large amount of data, and problems are difficult to find. I suggest you optimize the data model(A fact table and related dimension tables). Can the relationship be changed to a star structure? Maybe the problem will be corrected.

 

Best Regards

Janey Guo

 

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

Emmy66's avatar
Emmy66
Icon for Helper V rankHelper V
5 years ago

Hi v-janeyg-msft, thanks for responding to my query. We are planning on rolling out a datamart which I hope will alleviate the challenges I'm currently facing.