Filter works in Desktop but not in Web Service

[desasaurus]

I have a measure filtering a matrix, it works exactly as expected in the desktop but fails after publish. I can't interact with it in any way after publishing.

Desktop:

Web Service:

The Measure Im using to filter:

Epsilon =

var CPM =

IF(

CONTAINS('Project Leadsership', 'Project Leadsership'[email_addr], USERPRINCIPALNAME())

&& CONTAINS('Project Leadsership', 'Project Leadsership'[resp_type_code], "R10")

&& CONTAINS('Project Leadsership', 'Project Leadsership'[prj_status_ind], "A"),

1,

0)

var BUD =

IF(

CONTAINS('Organizational Leadership', 'Organizational Leadership'[Email Address], USERPRINCIPALNAME())

&& CONTAINS('Organizational Leadership', 'Organizational Leadership'[resp_type_code], "RM")

&& CONTAINS('Organizational Leadership', 'Organizational Leadership'[Organization Status Indicator], "A"),

1,

0)

var AM =

IF(

CONTAINS('Organizational Leadership', 'Organizational Leadership'[Email Address], USERPRINCIPALNAME())

&& CONTAINS('Organizational Leadership', 'Organizational Leadership'[resp_type_code], "AM")

&& CONTAINS('Organizational Leadership', 'Organizational Leadership'[Organization Status Indicator], "A"),

1,

0)

RETURN

IF(BUD+AM+CPM > 0, 1, 0)

Been stuck on this for a while any help is appreciated.

[Anand24]

Hi @desasaurus ,

The dependable function in your DAX is USERPRINCIPALNAME(). There are a lot of times that this function returns different values in Desktop and Services.

For Example:

USERPRINCIPALNAME() = FirstName.LastName@org.com in Desktop and USERPRINCIPALNAME()=SSO@org.com in services.

To check too, you can do one thing. Check what is the USERPRINCIPALNAME() value in desktop and put it as static value in your DAX. Try this in Desktop and Services.

Secondly, do try everything in incognito mode just to avoud any Cache dependency.

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[desasaurus]

I've already done this test, all our data lines up in both the desktop and web service. as per the picture above, the issue is that the filter simply isnt apllying on the webservice. my dax works fine and has no issues whatsoever in the desktop, and the USERPRINCIPALNAME function works perfectly as expected on both platforms as well.

[Anand24 · Accepted solution]

@desasaurus ,

Since you have tried almost everything, I guess the best option right now would be to raise a ticket with MS Support(Link) to understand the issue.

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[v-xulin-mstf]

Hi @desasaurus,

I created the measure with sample data but it works well in my environment.

You can republish the report and check.

Maybe the issue is not caused by the measure, please try to add other filters to test.

Looking forward to your reply.

Best Regards,
Link

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[desasaurus]

I've isolated this visual and filter away from the rest of the report in a new .pbix file and still no dice. I also removed the date and employee selection slicers and still no dice after publish. 

Thanks,

desasaurus

[v-xulin-mstf]

Hi @desasaurus

Please check if the UPN on the power bi service is the same as your local UPN.

After publishing to service:

Please check if the red marked parts are consistent.

If it does not, USERPRINCIPALNAME() will return different values on power bi desktop and power bi service.
Maybe this is causing your problem.

Best Regards,
Link

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[desasaurus]

My dax is working fine, USERPRINCIPALNAME has the same results in both platforms, and the only issue seems to be the filter not applying in the webservice.

[Fowmy]

@desasaurus 

Hope you check with the same user name both in the desktop and the service?
Create a measure like below and check to see

user = USERPRINCIPALNAME()

[desasaurus]

I've done this test before with a card to display results with multiple members of my organization. the measure seems to be working fine as it works exacltly as excpected in desktop.