Forum Discussion
Post PartisanData from a table (count and sum)
Administrator1) Medida = CALCULATE(COUNTROWS('Tabla'), REMOVEFILTERS('Tabla'[No], 'Tabla'[Fecha]))
apenarandaThe measure in point 2 makes the sum of all the registrations for that day, but what I want is to know how many different users there are with registrations that day.
Let's explain it in another way to see if it can be understood better:
Point 3 is basically the sum of records
Point 4, of the entire month (in this example case it is January), how many days there are with at least 1 record, that is, of the 31 days that January has, how many of them there are any records.- Syndicate_Admin
3) Las filas de conteo simples deberían ser suficientes
4) Aplique CountRows en la tabla donde la fecha está entre el inicio y el final del mes.
- apenaranda
2) I already get it, but would there be a way for me to also add up the total for every day?
Now it sets me for 1/1/2024 there are 2 users
For 2/1/2024 there are 3 users
I would only need the sum of all the days.
3) if correct, a count already adds up the records per day
4) I don't really understand what you mean.