Count users by min value in column grouping by type filtering by date

[Javi_Nofakes]

Hi everyone,

Thanks in advance for your answers. I've been trying to figure out the solution looking into the forum and other source and finally I have had to post the question hear.

I would like to get the number of users by type and month. For that, I've created a column with a rank of the sessions by the column event_ts in order by get the min rank of the rows filtered by date but without success.

# user by type = 
VAR min_user_type_row = 
CALCULATE(
    MIN('FACT - Analytics users'[row_num]),
    ALLSELECTED('FACT - Analytics users'[ga_session_id])
)
return
CALCULATE(
    DISTINCTCOUNT('FACT - Analytics users'[ga_session_id]),
    'FACT - Analytics users'[row_num] = min_user_type_row
)

This is a set of the original data.

 
And this one the result wanted.

[Ashish_Mathur]

Hi,

Your question is not clear.  Why are you creating the row_num column?  Why are you taking the minimum of that column?  Share some data, describe the question and show the expected result.

[Javi_Nofakes]

Thanks for your answer. Absolutely my explanation was not good at all, sorry. What I want to get is the number of users by "user_type" with the min "event_ts" in the range of dates selected. I think the screenshot above is clear to see the result after the new explanation, if not tell me and I can upload an pbix file. Thanks.

[Ashish_Mathur]

I just do not undestand.  Share an MS Excel file with the data and the expected result shown there.

[FreemanZ]

hi @Javi_Nofakes 

without writing any measure, if you feed event_date (month), user_type, user_pseudo_id (distinct count) to a table visual, you shall get what you expect, or?

[Javi_Nofakes]

Thanks for your answer. It is not exactly what I need. What I want to get is the number of users by "user_type" with the min "event_ts" in the range of dates selected. Thanks.