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)
Anonymous's avatar
Anonymous
Not applicable
4 years ago


It stills gives me an error..

I had some info to the original post

Richard_100's avatar
Richard_100
Resolver I
4 years ago

Hello

 

Try putting ' ' marks around all your references to Table.  DAX thinks you are calling the function TABLE()

 

Regards

Richard

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    That was it Richard, thanks for the detail!

    vikrambasriyar thanks for the solution!