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
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
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!!
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. | Proud to be a Super User! |
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
33 | |
15 | |
14 | |
12 | |
9 |