Forum Discussion

CLANG10's avatar
CLANG10
Icon for Helper I rankHelper I
4 years ago
Solved

Problem using sumx() with containsstring

Hi,     I am using CONTAINSSTRING to look for a specific text in a column, however i can't find the table/column, so i try using SUMX in the expression to be able to locate the column. An error occu...
Need Help
  • mangaus1111's avatar
    mangaus1111
    4 years ago

    Hi CLANG10 ,

    try this measure

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

CLANG10's avatar
CLANG10
Icon for Helper I rankHelper I
4 years ago

Hi seemd like my live data source is preventing me to use data transform/power query nor split any column. I can only create DAX measures, thus i can't test out your solution. Thanks anyway!

mangaus1111's avatar
mangaus1111
Icon for Solution Sage rankSolution Sage
4 years ago

Hi CLANG10 ,

try this measure

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • CLANG10's avatar
    CLANG10
    Icon for Helper I rankHelper I
    4 years ago

    Many Thanks, it works this way!!