Count ABC

[Syndicate_Admin]

I have this code:

COUNT ABC =

COUNTROWS(

FILTER(

VALUES(IMP_CUBO_VENTAS[ART_Id_Articulo]),

[ABC CLASSIFICATION]= Max(CLASE_ABC[CLASS])

)

)

What does this result give me:

But you see, I don't add the A's and the B's.

Please your help to fix it

Best regards

[v-kkf-msft]

Hi @Syndicate_Admin ,

Has your problem been solved? If it is solved, please mark a reply which is helpful to you.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

[Anonymous · Accepted solution]

Hi @Syndicate_Admin ,

Please try the measure

COUNT ABC = 
COUNTROWS (
    FILTER ( IMP_CUBO_VENTAS, [ABC CLASSIFICATION] IN VALUES ( CLASE_ABC[CLASS] ) )
)

Or

Measure = 
SUMX (
    VALUES ( CLASE_ABC[CLASS] ),
    CALCULATE (
        COUNTROWS (
            FILTER ( IMP_CUBO_VENTAS, [ABC CLASSIFICATION] = MAX ( CLASE_ABC[CLASS] ) )
        )
    )
)

My pbix file: Count ABC.pbix

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Syndicate_Admin]

Thanks for the reply.

But it still doesn't work.

[amitchandak]

@Syndicate_Admin ,

COUNT ABC =
COUNTROWS(
FILTER(
allselected(IMP_CUBO_VENTAS[ART_Id_Articulo]),
[ABC CLASSIFICATION]= Max(CLASE_ABC[CLASS])
)
)

or

COUNT ABC =
COUNTROWS(
FILTER(
allselected(IMP_CUBO_VENTAS),
[ABC CLASSIFICATION]= Max(CLASE_ABC[CLASS])
)
)