Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
ktg2019
Frequent Visitor

Remove filters from text values

I need to display the name of an organization in my report.

 

I currently have a custom-made filter to refer to the previous week of the year. However, whenever I use this filter, the organization name returns "(BLANK)" if there is no data for the week. I want the name of the organization to display regardless of whether or not that organization has data during that week.

 

I have tried using ISBLANK() functions with no avail. I cannot use the CALCULATE( REMOVEFILTERS()) command since the returning data is text. Are there any suggestions on how to remove the week filter from this organization name text value? 

 

Custom week filter: 

var weekref = if(WEEKDAY(NOW(),1) <= 5, WEEKNUM(NOW()) - 1, WEEKNUM(NOW())-1)
var class = if('Date'[year_key] = YEAR(NOW()) && 'Date'[WeekOfTheYear] = weekref, "PASS", "FAIL")
RETURN class
1 REPLY 1
RaocoSolutions
Regular Visitor

Can you provide dax from your Organization measure?
The above measure is returning pass-fail only an I don't see any issue with it. 

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.