Solved: Primary View displaying results that have value in... - Page 2

nadim_dayoub · 05-13-2021 08:04 AM

I have a Primary View with a log of my inventory. How do I only show rows with a value in column “Job Name”

I think I would be using this expression ISNOTBLANK(Inventory[Job Name])

but I am not sure where exactly to place this. I tried UX > Views > Log > Display > Show if

But it didn’t work… so I thought maybe I needed to make a “Slice” … soo I did that, but IDK how to apply it to my view “Log”.

Marc_Dillon

Expression of the form Table[Column] return a List of ALL values in the Column, for the entire Table.

Using a Slice is the correct way to go here. Your expression is close to correct, just remove the Table name.

You select what data the view points at from the UX>View, just select your new slice instead of the base Table.

Primary View displaying results that have value in a column