Removefilters not working in PBI Service

[PowerBiIsFun]

Hi All,

I'm trying to compare the data from one category to the average of all the categories.  I've used Removefilters( Projects[Category]) and it works great in PBI Desktop but stops working when I publish to the service!.... Is this a bug?  It seems so from my end.

Thanks,

Sarah

[Anand24]

Hi @PowerBiIsFun ,
It should be a bug since you are saying it is working in PBI Desktop but not in PBI Services because there is no DAX function that would create issue in only Services.

Please check the below though:
1. Try opening the report in Incognito mode so that browser cache is not affecting the report

2. Try publishing the report again

3. Try publishing the report to another workspace or my workspace to check any workspace issue

4. If none of the above feeds you appropriately, raise a ticket with MS Support reporting this as a bug 

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

[PowerBiIsFun]

Hi @Anand24 !

Thanks for the info - it turns out the removefilters function works in another workspace.... so what do I do now?  Of course the workspace where removefilters isn't working is my production workspace!  😞  Both are in a premium environment.

[Anand24 · Accepted solution]

@PowerBiIsFun ,
Try re-publishing once to the workspace and open it in incognito mode.

If issue still stays, please raise a ticket to MS Support. They can open the workspace logs and check 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