Forum Discussion
Tables with no relationship
In the below DAX code getting the following error :
The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
All =
Var N1 = convert(SELECTEDVALUE('slicer1'[datetime1]), DATETIME)
var Result = SUMMARIZECOLUMNS( table1[code1], table1[text1], "All",
CALCULATE( COUNTROWS(table2), FILTER( table2, table2[datetime2] <= N1
&& (ISBLANK(table2[col1]) || table2[col1] > N1)
&& (ISBLANK(table2[col2]) || table2[col2] > N1)
&& table2[code2] = RELATED(table1[code1] ) ) ) )
return Result
There is no relation between two tables.
The desire result which I want to get is a table with three columns: code1, text1, All
Any idea what should I change in DAX code for this error?
1 Reply
- lbendlin
Super User
As it says - SUMMARIZECOLUMNS creates a table. Your return statement needs a scalar value.
return SUMX(Result,[All])
would be one option.
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
