Forum Discussion
Helper IShow items without data, but with visual filters
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.
sample data ;
try the following :
create a new table calleddimdiscipline = 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! 🤠
1 Reply
- Daniel29195
Community Champion
sample data ;
try the following :
create a new table calleddimdiscipline = 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! 🤠