Forum Discussion
Calculate countif based on another table
Hi I have an excel table with a column for 'outcomes'. Users are able to add several outcomes, separated by commas. I have created a table in PBI which is just the possible 'outcomes' from the ...
Back2Basics I've generally done it this way:
New Column = LEN('Table'[Column]) - LEN(SUBSTITUTE('Table'[Column],",","")) + 1