Forum Discussion

jaw19883's avatar
jaw19883
Frequent Visitor
5 years ago
Solved

Like a COUNTIF in Excel

Ok - Here is my question. Very new to Power Bi, but well-versed in Excel. I have a column of data, that unfortunatley is not the best to play with, but none the less it is exported this way to me.  ...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    5 years ago

    The general pattern is to use filters. (See also the recommendations links in the sidebar.)

     

     

    CALCULATE (
    COUNT ( Table1[Section] ),
    FILTER (
        VALUES ( Table1[Section] ),
        CONTAINSSTRING ( Table1[Section], "G.CO.5" )
    )
)

     

    Edit: Changed LEFT condition to CONTAINSSTRING.

     

Fowmy's avatar
Fowmy
Super User
5 years ago

jaw19883 

You use the following measure to count the number of occurrences. This will count regardless of the position of the text where it appears. 

 

Count Enrollments = 
SUMX(
    VALUES(Table2[Courses]),
    INT(SEARCH("G.CO.5",Table2[Courses],,BLANK()) > 0)
)