Filter code by 2 conditions

[Syndicate_Admin]

Nice day

I need to filter the clients in Transforar Data whose code begins with the letter B and also those whose code is more than 5 characters long. This company has very different codes for its customers and in this case I need to see only those that meet one of these 2 conditions. Of course, I appreciate your help.

[amitchandak]

@Syndicate_Admin , Try a measure like

calculate(count(Table[Column]), filter(Table, left(Table[Code],1) = "B" && len(Table[Code]) >=5))

[Syndicate_Admin]

Good afternoon

I put together this formula as you told me (I tried the same with COUNT and the same thing happens)

BAG QUANTITY = CALCULATE(SUM(GVA53[QUANTITY]), GVA53, LEFT(GVA53[GVV12. COD_CLIENT], 1) = "B" || LEN(GVA53[GVV12. COD_CLIENT] >= 5))

and when I add it to a table, it returns this message to me:

Fields have the following type:

QUANTITY = DECIMAL NUMBER

COD_CLIENT = TEXT

Sipudieras help me, it would be great. Thanks a lot

Marcela Martinez Pagola

[PaulDBrown · Accepted solution]

Try:

BAG QUANTITY =
CALCULATE (
    SUM ( GVA53[QUANTITY] ),
    FILTER (
        GVA53,
        LEFT ( GVA53[GVV12. COD_CLIENT], 1 ) = "B"
            || LEN ( GVA53[GVV12. COD_CLIENT] >= 5 )
    )
)