Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Count repeated shippment methods

Morning,   I have 3 columns as following in the table below:   Date ID Method 01/01/2021 1 A 01/01/2021 2 A 02/02/2021 1 A 02/02/2021 2 B 10/04/2021 1 C 11/04/202...
  • vikrambasriyar's avatar
    4 years ago
    REQMeasure = 
    VAR __vix=FILTER(
               SUMMARIZE(Tablex,Tablex[ID],Tablex[Method],"@cnt",COUNT(Tablex[ID])),[@cnt]>1)
    RETURN
    COUNTROWS(__vix)