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.
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?
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.
Ok so i have named the coloums and the table? and it is still the same error? could you show your example?