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