DIstinct filter by column and measure

[Digger]

I have measure

    CALCULATE (

       [Sales, Pcs],

        FILTER (

            DISTINCT (FullFillment[Code]),

            COUNTROWS (

                FILTER (

                   'CustomTable',

                   [TurnoverCategory]='CustomTable'[ShortName]

                )

            ) > 0

        )

    )

But it count only one column, and show only in one category

But i need split by all TurnoverCategories
something like that

    CALCULATE (

       [Sales, Pcs],

        FILTER (

            DISTINCT (FullFillment[Code] && Measure_TurnoverCategory),

            COUNTROWS (

                FILTER (

                   'CustomTable',

                   [TurnoverCategory]='CustomTable'[ShortName]

                )

            ) > 0

        )

    )

[amitchandak]

@Digger , Nor very clear. Just check Are you trying something similar

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://www.youtube.com/watch?v=W4EF1f_k6iY

[Digger]

@amitchandak  not on that side at all