countrows if

[MP_123]

hi,
i am using power bi and i'm try to applying some dax function without success.

date	sign	dev	market	#users	dev2	count
1/1/2016	ab cd	ios,android	USA	100	ios	2
1/1/2016	ab cd	ios,android	USA	100	android	2
2/2/16	re re	ios, PC	Canada	52	ios	1

<tbody>
</tbody>

i want to add a dynamic measure - count, that counts the rows that are exact the same, except the 'dev2' column.
i want it to by dynamic since i want it to affect from the slicer: for example if i won't choose ios in dev 2, i will get only the second row, and count will be 1.

in sql i would join between two tables and the compare a.date=b. date, etc..
thanks!

 

[Useful]

Hello, and Welcome!

try

= COUNTROWS(GROUPBY(Your Table Name,[date],[sign],[dev],[market],[#users]))

or use Summarize instead of GroupBy