Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Get Activities by comparing between two or more projects in Power BI

Hi,  Here I am trying to compare two projects by creating a slicer visual where one is "BASELINE" and the other is "CURRENT", so when I select a project_id from "BASELINE" and another project_...
Need Help
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,
Based on your changes, I modified my dax as follows

Exist_in_Baseline = 
IF(
    CALCULATE(
        COUNTROWS(BASELINE),
        FILTER(
            ALL(BASELINE),
            SELECTEDVALUE('CURRENT'[proj_id]) <> SELECTEDVALUE(TASK[proj_id]) 
        )
    ) > 0 ,
    "Yes",
    "No"
)
Exist_in_Current = 
IF(
    CALCULATE(
        COUNTROWS('CURRENT'),
        FILTER(
            ALL('CURRENT'),
            SELECTEDVALUE(BASELINE[proj_id]) <> SELECTEDVALUE(TASK[proj_id]) 
        )
    ) > 0 ,
    "Yes",
    "No"
)

Fianl output

Best regards,

Albert He

 

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

One more thing is like for example from the below image "C321" and "R214" are present in both the projects so the Exist_in_baseline and Exist_in_current should be "Yes" in both the cases.