Forum Discussion

Ht787's avatar
Ht787
New Member
1 year ago

Columns missing

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

3 Replies

  • KNP's avatar
    KNP
    Super User
    1 year ago

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

     

  • shafiz_p's avatar
    shafiz_p
    Super User
    1 year ago

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