topic Re: Columns missing in DAX Commands and Tips

Columns missing

Ht787 — Thu, 31 Oct 2024 00:06:51 GMT

New user here.

I'm using the following query, but where i'm using 'DEALS'[Sales Agent] and [Energy Specialist], I can't find either of those columns. I can only see 6 out of my 17 columns.

AgentTypeFilter = VAR SelectedAgent = SELECTEDVALUE(AgentTypeToggle[Agent Type], "Both")
RETURN
SWITCH(
TRUE(),
SelectedAgent = "Sales Agent" && NOT(ISBLANK('DEALS'[Sales Agent])), TRUE(),
SelectedAgent = "Energy Specialist" && NOT(ISBLANK('DEALS'[Energy Specialist])) && ISBLANK('DEALS'[Sales Agent]), TRUE(),
SelectedAgent = "Both", TRUE(),
FALSE()
)

Appreciate any help

Re: Columns missing

FreemanZ — Thu, 31 Oct 2024 00:18:54 GMT

hi Ht787 ,

how are the two tables related: AgentTypeToggle and DEALS?

Re: Columns missing

KNP — Thu, 31 Oct 2024 00:41:58 GMT

It's not really clear what you mean but if this is a measure, you'll need to wrap your columns in a min, max or selectedvalue depending on your use case.

e.g. NOT(ISBLANK(MIN('DEALS'[Sales Agent])))

Re: Columns missing

shafiz_p — Thu, 31 Oct 2024 03:30:42 GMT

Hi Ht787 Try refreshing data, check applied steps in the power query. For example, a Removed Other Columns step might be excluding the columns you need. Ensure that the columns are not hidden.

Hope this helps!!