Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Ht787
New Member

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 3
shafiz_p
Solution Sage
Solution Sage

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
Super User
Super User

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 ;).
chrome-9xf-Zagzel-B

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.
KIfp67uy-Sr
Proud to be a Super User!PBI-Super-User-Rank-30x30-1x
FreemanZ
Super User
Super User

hi @Ht787 ,

 

how are the two tables related: AgentTypeToggle and DEALS?

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors