Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Power BI Count IF Like

I have a spreadsheet which gets updated weekly and then have a dashboard in PowerBI. I want to be able to Query coloum 3 for all names like DA_ and then count coloum 4 for enabled/disabled

 

Is this possible?

Need Help
Tips and Tricks
  • ZunzunUOC's avatar
    ZunzunUOC
    7 years ago
    MeasureCount = CALCULATE(COUNTROWS(Like);FILTER(Like;LEFT(Like[SamAccount];3)="DA_" && Like[enable]="TRUE"))

     

    Best Regards,
    Miguel

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

19 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

       

      Thats what the excel is like?

      • ZunzunUOC's avatar
        ZunzunUOC
        Resolver III
        7 years ago

        Ok, you can create a calculated column like this:

         

        enable = IF(LEFT(Like[SAMACCOUNT];3)="DA_";"TRUE";"FALSE")

        I recognize what you mean with count.

         

        Best Regards,
        Miguel

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