How can I extract a single row of a table with a custom Filter, store it in a variable for further use, and then extract a sigle value from one of it columns ? Right-click the table, and then select Add related tables from the menu that appears. From my understanding Contains takes a (table, comparision that returns T or F). SELECT conversion_rate FROM DimCurrenciesRates. And if I did answer your question, please mark this post as a solution. In both cases, if you have additional slicers/filters in the visual, then use CALCULATETABLE around your query to manually pass all those filters. Asking for help, clarification, or responding to other answers. Selected = COUNTROWS (FILTERS ('Table ['Name])) this is to get how many filters are selected in the visual I am then setting this condition using the above measure IF ( [Selected] > 1 ; MAX (Table [Name1]) ; MAX ('Table' [Name2])) Both are always returing the same column regardless of the condition. QGIS automatic fill of the attribute table by expression, Short story about swapping bodies as a job; the person who hires the main character misuses his body. Do i want to filter on the outside of the DAX query? RELATED When using Selectcolumns, the first parameter is a table expression, and after that there are pairs of parameters consisting of: Using Filter as the first parameter in your expression, Selectcolumns already have a table syntax, then the second builds should be a new column name, but based on what has been posted, there are two table syntax here. DAX - SelectColumns->Filter->Contains Syntax Which ability is most related to insanity: Wisdom, Charisma, Constitution, or Intelligence? DAX - Reference measure in calculated column? A variable is actually a Constant. today = FILTER ('date', 'date' [Date] = TODAY ()) But here today has many fields, while I just want to return the week. Can my creature spell be countered if I cast a split second spell after it? show please an example of your data model. Returns a table with selected columns from the table and new columns specified by the DAX expressions. What were the poems other than those by Donne in the Melford Hall manuscript? Edit data models in the Power BI service (preview) - Power BI Strictly speaking, non-X functions are not iterators and table variables are just logical tables, which might suggest they cannot skip iteration and give you the max or min value you want. The table to be filtered. I only want to sum the values below 0.5 in my column. Combine PowerBI DAX Filter and SELECTCOLUMN. Table tar command with and without --absolute-names option, Generating points along line with specifying the origin of point generation in QGIS. i actually moved on from this problem because i decided that i could filter with the slicers. Returns a table with selected columns from the table and new columns specified by the DAX expressions. Create a new table in Power BI Desktop itself with the red query and see the output. SELECT conversion_rate FROM DimCurrenciesRates. If total energies differ across different software, how do I decide which software to use? I headed into the same issue just now and the error message was clear enough to say Max function accepts columnreference only, even if you table variable has one column only, which is still considered as a table not column.