Re: Columns missing

Ht787 · ‎10-30-2024

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

shafiz_p · ‎10-30-2024

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!!

KNP · ‎10-30-2024

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])))

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.