cancel
Showing results for 
Search instead for 
Did you mean: 

Removefilters isn't working in my production workspace

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!

Status: Investigating

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

Comments
v-cazheng-msft
Community Support
Status changed to: Investigating

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
Frequent Visitor

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..... 😞