The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have a column with text and i'm trying to create a measure that will count the amount of times two words appear together.
For example:
Word 1: Text 1
Word 2: Text 2
Text 1 - Text 1 - Text 1 - Text 2
Text 1 - Text 3 - Text 1 - Text 3
Text 1 - Text 2 - Text 1 - Text 1
Text 1 - Text 2 - Text 1 - Text 1
Text 1 - Text 1 - Text 1 - Text 3
Text 1 - Text 1 - Text 1 - Text 3
Text 1 - Text 1 - Text 1 - Text 4
Result: 3 (as text 1 and text 2 appear together on 3 different rows)
I have the following dax that converts selections in splicers to strings:
The code doesn't error, but nothing is returned. Am i using the wrong contains? Or is something else off.
TIA
Hi @EddP
perhaps you need to include the delimiter (seperator) and spaces.
VAR inp = t1 & " - " & t2
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
36 | |
14 | |
12 | |
7 | |
7 |