Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all
I'm trying to countrows of a column that contain different regions. My column looks similar to this:
[Region]
ANZ
ANZ, Americas
ANZ, EMEA
EMEA, Americas
I want to countrows (presumably will use a filter) but not [Region] = "ANZ" as that won't pick up the ANZ in the other rows. where it is combined with another region. What can I use to count the times ANZ appears in the column, regardless of the other values in the cell.
Thanks!
Solved! Go to Solution.
May be
Measure = CALCULATE ( COUNT ( Table1[Region] ), SEARCH ( "ANZ", Table1[Region], 1, 0 ) > 0 )
May be
Measure = CALCULATE ( COUNT ( Table1[Region] ), SEARCH ( "ANZ", Table1[Region], 1, 0 ) > 0 )
Thank you! This is great.
Could I just ask why the >0 sits at the end (so I understand it all) ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |