Removefilters isn't working in my production workspace

[PowerBiIsFun]

Hi There,

My formulas using removefilters work in Power BI Desktop and in a workspace I use for development but when I publish the same file to my production workspace the removefilters function seems to no longer work!

I've tried looking at the report in Incognito mode and republishing the .pbix multiple times.

How do I fix this?

TIA!

[v-cazheng-msft]

Hi @PowerBiIsFun,

Could you please let me know how you use the Removefilters function with more details? If it is convenient for you, could you please provide a download link of a sample pbix file that contains your problem? Thanks in advance!

REMOVEFILTERS function (DAX) - DAX | Microsoft Docs

Best regards,

Community Support Team _ Caiyun

[PowerBiIsFun]

Hi @v-cazheng-msft ,

Yes, I am working with a Projects and Tasks table like below:

Projects

ProjectId   Category     

1               X

2               Y

3               X

Tasks

ProjectId        TaskId        Duration

1                     1.1             a

1                     1.2             b

1                     1.3             c

My first measure is:  AvgDuration = Calculate( Average( Duration ) )

My second measure is AvgDuration All Categories = Calculate( [AvgDuration], Removefilters( Projects[Category] ) )

I want to look at the average duration of the tasks by category and compare them to the average of all tasks.  I want to use Matrics and Line Chart visuals.

@v-cazheng-msft Any update on this?  I have a large audience and this is not a good issue to have..... 😞