Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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:
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.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 21 | |
| 10 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 32 | |
| 31 | |
| 20 | |
| 12 | |
| 12 |