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
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

Could you describe your question in simple English (instead of sharing an SQL statement), share a small dataset(s) and show the expected result.

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

Hi Ashish_Mathur thanks for your reply. I'm trying to count the number of progress updates based on this formula. Pbix file shared in my reply above.

ProgressUpdate =

    CALCULATE(

    COUNT(Progress[progressId]),

        FILTER(Progress,Progress[status]=1),

            FILTER(Project,Project[status]=1

            && Project[accepted]=1

            && Project[archived]=0),

                FILTER(Project_Sheet,Project_Sheet[status]=1

                && Project_Sheet[os_archived]=0))

result is 1730 but the expected output should be 1646. I suspect the reason is because of the inactive relationship between Project & Project_To_Progress. I applied the USERELATIONSHIP function to the above query but instead it retruned blank (USERELATIONSHIP(Project_ToProgress,Project). I hope my explanation helps. Thanks in advance for your assistance.