Forum Discussion
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...
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.
Thats what the excel is like?
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.
Getting the following error. Even if i change SAMACCOUNT in the query to Column3 it gives the same error?
"like" is your table name?
The table in this instance is called "test" but even that does not work?