Forum Discussion
Power BI Count IF Like
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.
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?
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.Could you change ";" per ","?
So that seems to of fixed the ; issue. However it doesn't seem to allow me to count the enabled accounts?
Have you create a calculated column?
Ok i see now it works. However, that is not what i was looking for? I wanted to be able to add a measure so i can show it on a dashboard. I want to be able to Count all accounts which start with DA_ and in the enabled coloum are True. so if there are 30 accounts and only 10 are enabled it will show 10 not 30.
Ok, try with this:
MeasureCount = CALCULATE(COUNTROWS(Like);FILTER(Like;Like[enable]="TRUE"))
But i only want to count it if it has DA_ in SamAccount?
Then, change the code to:
MeasureCount = CALCULATE(COUNTROWS(Like);FILTER(Like;LEFT(Like[SamAccount];3)="DA_"))
But that doesnt do both so i need to count the enabled accounts that match DA_?
Thank you :)
Anonymous
By the way, you may help accept the solution above. Your contribution is highly appreciated.
