Forum Discussion

Anonymous

Not applicable

1 year ago

Solved

undefined

I am looking for the answers for this : Mdxscript(Model) (264,25) calculatiuon error in measure 'xyz'[outflow]:Function 'CONTAINSROW' doesnot support comparing values of type text with the values of ...

Need Help

Joe_Barry
1 year ago
Please try this

Total = CALCULATE(ROUND(SUM('Table'[A]) + SUM('Table'[B]) + SUM('Table'[C])+ SUM('Table'[D]) + SUM('Table'[E]), 0))

I'm not sure how your data is structured, but you van do this Power Query too if you chaning the table format isn't an issue.

Highlight all the columns that you want to sum

Right click and choose unpivot columns. You will be left with the columns that you didn't highlight and two new column. one showing the column names and another with teh amounts.

Load into the report

Adapt the measure above to just

Total = CALCULATE(ROUND(SUM('Table'[Value]), 0))
Anonymous
1 year ago
Thank you for the suggested solution .It worked partially .The main problem is it has some blank values which are not well treated .After replacing blank with zero it worked.

Joe_Barry

Solution Sage

1 year ago

Hi Anonymous

It seems you are trying to compare two columns that have differnt formatting. This could be a number column being compared to what looks like a number column but is formatted as text. Check both columns to see if they are formatted as numbers

Hope this helps

Joe

Anonymous

Not applicable

1 year ago

Thank you Joe for the response.I checked both the columns are in Decimal Format.

Joe_Barry
Solution Sage
1 year ago
Can you share the measure that you trying to implement and a screenshot of the column headers in Power Query ? Hopefully then I can help further
- Anonymous
  Not applicable
  1 year ago
  the measure i used is :
  
  OutFlow sum = ROUND(
  CALCULATE(
  SUM(Table name[column name]),
  'Table name'[column name] IN {"x",
  "y",
  "z",
  "A",
  "B",
  "C",
  "U",
  "V",
  "W",
  "M",
  "O",
  "H",
  "L",
  "R",
  "S",
  }
  ),0
  
  )
  AND THE COLUMN NAMES HAS VALUES LIKE 124.90,3747632965234756.05,76443765,5 ETC
  - Joe_Barry
    Solution Sage
    1 year ago
    Please try this
    
    Total = CALCULATE(ROUND(SUM('Table'[A]) + SUM('Table'[B]) + SUM('Table'[C])+ SUM('Table'[D]) + SUM('Table'[E]), 0))
    
    I'm not sure how your data is structured, but you van do this Power Query too if you chaning the table format isn't an issue.
    
    Highlight all the columns that you want to sum
    
    Right click and choose unpivot columns. You will be left with the columns that you didn't highlight and two new column. one showing the column names and another with teh amounts.
    
    Load into the report
    
    Adapt the measure above to just
    
    Total = CALCULATE(ROUND(SUM('Table'[Value]), 0))