Searching a slicer in my Direct Query report blows it up (ORA-00904)
Good afternoon! Anonymous and I are building a report that performs a Direct Query to an Oracle database with a custom SQL query (that we feel is optimized) through a gateway. We originally had several search boxes with the Text Filter visual added, but when we would search we would immediately lose all the visuals. We replaced this with a slicer. It takes a moment for all the values to load, but when we select one it works. If we attempt to search the slicer at all, we lose the slicer visual with an ORA-00904 (invalid identifier) error. If the slicer has loaded all the selections, is it passing the search through SQL? I assumed it would just search in local memory. Do we need to do something funky to the SQL query? Is this just an optimization issue? Hopefully we're not the only people fighting this. Thanks in advance!
Count appearance of string in a comma-separated data column does not count values after the first co
I have two tables: Products table has a single column with one product per field: List table has several columns but the column I'm interested in has fields that can have as little as one product to as much as 17, all separated with a comma and no spaces in between: The issue I'm facing and need help with is to correctly count each product either, ideally as as a measure. I tried two measures but they both gave me an incorrect count of blanks; there are no blank values either table. What I found is that both measures count only the *first* value they find in the List column and then continue counting subsequent rows: How can I correctly count all values in each field from the List table and have zero "blank" counts? Thanks!
Lookup value within date range
I'm looking for a dax formula for a calculated column, which searches by name and between two dates. In the picture below the explanation. I'm looking for a DAX formula (calculated column) for the orange column in table_1. I have found many similar questions with solutions on the internet. However, those solutions just don't work. I hope someone can help me with the final solution through this community site. Thanks in advance for the help! Bas.
Search In Different Order
I'm looking to have a search field that looks in a table where it searches the same words, but the words could be in a different order. In excel, it would be similar to the contains and contains filter instead of the exact filter. Example Description Field: Pen Blue Medium Bic In the search field if "blue pen" is entered I would like for this description to come up. It's only coming up if I type the words in the exact same order. Eg. "Pen blue", "blue medium" & "medium bic" Thanks in advance for your help! 🙂 LaurindaCount / countrows of column in fact-table combined with search slicer
Dear Community! I have a challenge I do not seem to be able to solve alone. In my fact-table, one column has all the names of salesagents. It can be one agent only, or several. If more than one, the value is delimited by ";". To be able to slice based on each salesperson, I have set up an unrelated table, that contains all salesagents, one row per agent. I use this unrelated table in a slicer, combined with a SEARCH-function, I check whether the agent can be found in the fact table column. If the search-measure to filter the visualizations and it works well. Problem: If I try to count the rows matching the search, and putting it in a card, it fails. My search-function is set ut like this: mAgent_Search = SEARCH( SELECTEDVALUE(UnrelatedTable[AgentName]), SELECTEDVALUE(FactTable[AgentNames]),, -1) I would need a card that counts the number of rows that is in the fact table, filtered for all 'normal' slicers AND the slicer that is search-based on the UnRelatedTable's AgentName. Is there a way to do this? Very much appreciate any help. Best regardsWildcards with IF in DAX
Hello All, I have a table like this in Excel where column "B" is bringing "TRA" everytime it finds that word within the codes in column "A"... no matter where "TRA" is positioned in the word. For doing so, i'm using ISNUMBER + SEARCH formulas and works like a charm. Can you guys please help me replicate this in DAX?? This is the formula in cell B2: =IF(ISNUMBER(SEARCH($B$1;A2));"TRA";"") Thanks! EdsonCompare data from different dates in the same table
Hi everyone, I have a data base that updates everyday with new information and I would like to bring the data from the previous day to a new calculated column to be compare with the data from today. Here's a example for better explanation: I have that idea, but maybe there's a better solution for this problem, also I would like to create a matrix with the items in the row section, the 2 dates as columns and other column with the delta of the values. Hope anyone can help, thanks!
