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...
COUNT
COUNTROWS
returns
  • vikrambasriyar's avatar
    vikrambasriyar
    4 years ago
    REQMeasure = 
VAR __vix=FILTER(
           SUMMARIZE(Tablex,Tablex[ID],Tablex[Method],"@cnt",COUNT(Tablex[ID])),[@cnt]>1)
RETURN
COUNTROWS(__vix)
vikrambasriyar's avatar
vikrambasriyar
Icon for Helper I rankHelper I
4 years ago
REQMeasure = 
VAR __vix=FILTER(
           SUMMARIZE(Tablex,Tablex[ID],Tablex[Method],"@cnt",COUNT(Tablex[ID])),[@cnt]>1)
RETURN
COUNTROWS(__vix)