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 thi...
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.

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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Getting the following error. Even if i change SAMACCOUNT in the query to Column3 it gives the same error?