topic Re: Count repeated shippment methods in DAX Commands and Tips

Count repeated shippment methods

Anonymous — Wed, 09 Feb 2022 12:34:24 GMT

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/2021	3	C
06/06/2021	2	B
07/06/2021	2	B
09/08/2021	1	A
09/08/2021	2	A
09/08/2021	3	A
15/09/2021	3	B

I would to calculate how many ID came back using the same Method.

In this example, the output should be a visualization as seen in the table below:

Method	Count
A	2
B	1
C	0

The last line can be left out.

Should I use a variable to build a calculatetable and the countrows? I'm having trouble summarizing the data and the acess the table as a variable.

Thanks

Re: Count repeated shippment methods

vikrambasriyar — Wed, 09 Feb 2022 12:16:43 GMT

REQMeasure = VAR __vix=FILTER( SUMMARIZE(Tablex,Tablex[ID],Tablex[Method],"@cnt",COUNT(Tablex[ID])),[@cnt]>1) RETURN COUNTROWS(__vix)

Re: Count repeated shippment methods

Anonymous — Wed, 09 Feb 2022 12:25:11 GMT

vikrambasriyar thanks for the reply! This solution you provide returns an error: "The syntax for 'Table' is incorrect. (DAX(VAR __vix = FILTER ( SUMMARIZE ( Table, Table[ID], Table[Method], "@cnt", COUNT(Table[ID]) ), [@cnt] > 1)RETURNCOUNTROWS(__vix)))."

Re: Count repeated shippment methods

vikrambasriyar — Wed, 09 Feb 2022 12:30:52 GMT

Use as a measure and replace the table name in the DAX.

Re: Count repeated shippment methods

Anonymous — Wed, 09 Feb 2022 12:37:07 GMT

It stills gives me an error..

I had some info to the original post

Re: Count repeated shippment methods

Richard_100 — Wed, 09 Feb 2022 12:39:49 GMT

Hello

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

Regards

Richard

Re: Count repeated shippment methods

vikrambasriyar — Wed, 09 Feb 2022 12:58:25 GMT

Try removing the '' marks

Re: Count repeated shippment methods

Anonymous — Wed, 09 Feb 2022 13:23:20 GMT

That was it Richard, thanks for the detail!

vikrambasriyar thanks for the solution!