Xlookup from string
Dear All, We are getting data in the below format where we are getting Raw value against each point and we need to identify it's state based on the metata in the State column coming in as a string value. E.g. Point ID 1 should have occupancy state as Unoccupied where as Point ID 2 should have occupancy state as Occupied. Expected Values We are dealing with huge timeseries sensors data coming in every 15 minutes. Kindly provide us the logic DAX or Custom column logic which should have minimum performance impact. Also please suggest is this too bad to implement this in Power BI? Thanks!Filter rows if they contain at least one value from a text array
I'm trying to show total sales for a products, witch name string contains at least one of the keywords from a static table. Here is the formula for it: Sales by Group, EUR = CALCULATE ( [Sales, EUR], FILTER ( 'Sales Product Lookup', CONTAINSSTRING( 'Sales Product Lookup'[Product Name], MAX('Table Keywords'[Keyword]) ))) For now it's pretty useless and only works for visuals in the form of a table where one of the columns = Table Keywords'[Keyword]. How can I force the CONTAINSSTRING function to accept array/column instead of single value? Will be realy appreciate for the help!
Measure based on looking for a string inside another string
Hi everyone! I'm working with sports data and would like to know if there is any way to find a string inside a column (also a string) filtered for a third column. For example, the one below: - To find the Player column (from Player table) inside the FiveOnCourt column (from Plays table) based on Full_Game column. The goal is to get how many games one player played (every game has a different value in Full_Game column). Secondly, I would like to know if, filtering for the MAX of Índice column + a Full_Game (to do the search in a game), it's possible to do the same exercise [To find the Player column (from Player table) inside the FiveOnCourt column (from Plays table) based on Full_Game column. The goal is to get how many games one player played.]. The goal here is to know if a player started the game. If the string (Player) is in FiveOnCourt field, there would be yes and a starting five player, otherwise, the Player would not be in Starting Five. Add you the pbix file and raw data: https://drive.google.com/drive/folders/1BxVWCtoHkcQYnDfOpqmYFpFgXpoEIPOt Thank you for your time.Help with filtering table based on filter string
I hope someone can help with this problem. So I'm trying to create a DAX measure, that needs to filter some account numbers in a table based on a string. The string contains both ranges and specific account numbers, and looks like this: 01011..01090|01901..01902|01904..01959|01980..01998 I can then fetch that value in my measure with this variable: VAR FilterString = CALCULATE( SELECTEDVALUE( 'Account Schedule'[Totaling]), 'Account Schedule'[Row No_] = "01090" ) However, how do i then translate that string into a useable filter?
Filter table by string from another table
Hello, my friends. Tenho a seguinte situação. Na tabela 1 tenho uma coluna com números de contrato (1000, 1001, 1002, 1003, n) Na tabela 2 tenho uma tabela de fornecedores que podem atender vários contratos. Nesta tabela há uma coluna com os números de contratos atendidos, porém os números estão inseridos da seguinte forma em cada célula: 1000; 1003 (separados por ponto e vírgula). Preciso inserir uma segmentação de dados pelo número do contrato (da tabela 1), e que esta consiga filtrar a tabela 2 que contém os dados aglutinados com ponto e vírgula (algo como uma CONTAINSTRING) Alguém consegue me auxiliar nesta missão?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!Combing TREATAS, COTAINSSTRING and CONCATENATEX issue (Icon Map)
Hi all, I have quite a bespoke issue that I can seem to find a resolution for (either by my own working or by searching online). I have a column of data in one table that has a corresponding strings such as bellow: Legend NO2 Cat 19-22 40-44 19-22 34-37 19-22,28-31,40-43 You'll note that in the last entry, multiple caterogries are included as the object encompasses multiple catergories. I have a second table (which is actually more of a legend as this is being used for a map) with the same list of corresponding catergories. The idea is that when someone clicks a catergory, or multiple catergories, within that table, it will filter the table above. Because of some quite deep complexeties with the Icon Map visualisation I am using, I cannot use a direct relationship so I have to use TREATAS. I have come up with a DAX that almost gets me where I need to be and is as follows and uses a CONCATENATEX on the fitlering table to create a single object (as Icon Map does not like tables of multiple values) (legendcheck2 is the filtering context and SNAMaster is the primary dataset)(ignore the switch): Value = SWITCH('Measures Table'[SelectionMeasure],1,CALCULATE(SELECTEDVALUE(SNAMaster[NO2_mean]), TREATAS(SUMMARIZE(FILTER(SNAMaster (CONTAINSSTRING(CONCATENATEX(VALUES(legendcheck2[CAT]),legendcheck2[CAT],","), VALUES(SNAMaster[Legend NO2 Cat])))),SNAMaster[Legend NO2 Cat]),SNAMaster[Legend NO2 Cat]))) This allows the last object in the table to be included but only when all of the catergories listed are selected. So for example, as long as 19-22,28-31,40-43 are within the selection criteria, the object will show. However, if for example I wanted to select just 19-22, the object will not appear. I understand why this is, because it cannot find the string as intended, but I am at a loss for how to resolve this issue so that the object will remain active when filtered by any combination of values selected. So that, for example, if I have 19-22 and 40-43 selected, the object will remain active. Am I missing something obvious here or should I be trying something entirley different? Any help would be greatly appreciated!
