Show items without data, but with visual filters

[mikesdunbar]

I'm working on a problem tracking database, and need to filter some things like 

• Pending items in the past 90 days
• Number of pending for discipline 

For the example highlighted, I used Filters on this Visual, for the last 90 days, and Status as Pending. What I want to see in that table are all the other disciplines with a value for zero or blank. I tried using Show items with no data and it doesn't do that.

[Daniel29195 · Accepted solution]

sample data ; 

 

try the following : 
create a new table called

dimdiscipline = distinct ( tbl_name[discipline]) 

link this table as 1 to many to your original table :  discipline to discipline. 

 

now create a measure : 

Measure =
SWITCH(
TRUE(),
not ISEMPTY(treatas(VALUES('Table'[c]),t[c])),CALCULATE(SUM('Table'[qty])), 0
)

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠