Forum Discussion

Emmy66's avatar
Emmy66
Helper 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
Community Support
5 years ago

Hi, Emmy66 

 

After testing, the filter fuction you wrote seems to be redundant.You can delete it then will get the right value.

Like this:

 

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
    Helper V
    5 years ago

    hi v-janeyg-msft , thanks for your reply. The conditions are required. What I attached is a sample extract based on the conditions included in the filter in the SQL inorder to reduce the volume of data. Each table has records of over 100K, so without the filters I will be doing just the count of records and that will not produce the required result. Apologies if my explanation wasn't clear earlier.

    • v-janeyg-msft's avatar
      v-janeyg-msft
      Community 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
        Helper 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.