How to get Measure work for Slicer Position "all"

[AntonioStyrov]

Hi community. 

It my the first post. I really got a lot of help from all topics creating my report.  And I stucked at very trivial point. 

When my slicer is in exact position -  measure is working correctly calculating "UserTestInScope". When the slicer is not aplied which means count all it returns the first available Value when User is "Blank" 

There are screens and code example below: 

#UserTestInScope = 
VAR Reference_Mail = SELECTEDVALUE('User'[displayName])
VAR Reference_Phase = SELECTEDVALUE(Phases[ExecutionReference_TestSuite.TestPlanTitle])
VAR Result = 
    COUNTROWS(FILTER(
            ALL('UserTestRuns'),
            AND(Reference_Mail = 'UserTestRuns'[AssignedTo.UserName], Reference_Phase = 'UserTestRuns'[TestSuite.TestPlanTitle])
        ))
RETURN Result

 

displayName field  slicer I tried to get from User table and from UserTestRuns Table. 

I feel that I'm missing some stupid thing in table connections or in measure. Can you help me with it? Probably there is some tip.

Link to pbix and the data included: Link 

Kind regards and many thanks in advance,

Anton

[AntonioStyrov]

Hi Aisa. 

It took some time to clean up the data. The link is attached in original post

[v-yetao1-msft]

Hi @AntonioStyrov 

From the information you provided, I have no way to determine the exact cause. Can you provide your pbix file for reference?

Best Regards,
Community Support Team _ Ailsa Tao