How to get Measure work for Slicer Position "all"

AntonioStyrov — Mon, 19 Dec 2022 13:44:58 GMT

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

Re: How to get Measure work for Slicer Position "all"

Anonymous — Fri, 16 Dec 2022 07:48:43 GMT

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

Re: How to get Measure work for Slicer Position "all"

AntonioStyrov — Mon, 19 Dec 2022 13:45:39 GMT

Hi Aisa.

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

topic How to get Measure work for Slicer Position "all" in DAX Commands and Tips

How to get Measure work for Slicer Position "all"

Re: How to get Measure work for Slicer Position "all"

Re: How to get Measure work for Slicer Position "all"