Filter the results of a measure

[djwitkowski]

Hello,

I am trying to count the number of duplicate items for X number of shipments selected. I have a measure:

Test1 = CALCULATE(DISTINCTCOUNT('To Power BI'[Material]), FILTER('To Power BI', COUNT('To Power BI'[Shipment Number]) > 1))

This seems to somewhat work, because it puts a 1 next to each item that shows on more than 1 shipment, but the totals are incorrect. Any ideas how I can count the number of items that appear more than once on the selected shipments?

Thanks!

[Fowmy]

@djwitkowski 

Can you try this measure?

Test1 =
COUNTROWS (
    FILTER (
        SUMMARIZE (
            'To Power BI',
            'To Power BI'[Material],
            "C", COUNT ( 'To Power BI'[Shipment Number] )
        ),
        [C] > 1
    )
)

[Jihwan_Kim · Accepted solution]

https://www.dropbox.com/s/50pyxt1b7a5t5to/djwit.pbix?dl=0

Test1 =
CALCULATE (
DISTINCTCOUNT ( 'To Power BI'[Material] ),
FILTER ( VALUES ( 'To Power BI'[Material] ), [Shipment Number] > 1 )
)