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.
ZunzunUOC
Resolver III
Resolver IIIOk, 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?
- ZunzunUOC
"like" is your table name?
The table in this instance is called "test" but even that does not work?
- ZunzunUOC
Ok, I see two wrong things:
- Names. You must change my names for your names (table and columns).
- In your capture, your columns has no names. You must define the first row like a header.
Otherwise, I test the code and works fine. Give me your feedback and see it.