Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

Problem creating a table that counts how many times a user entered the application

Hi, I need to create a measure that says how many days a user logged into my app.

My table called ingresos_totales has a row for each time a customer entered the app and the date they entered. My problem is that when I create a table to count the days that a customer came in, I get an error in the DAX code.

My code is as follows:

Total Revenue = SUMMARIZE('ingresos_totales',
(ingresos_totales[cliente_id]),
"Amount of Revenue", COUNT(ingresos_totales[start date].[He] was))
What would you be missing?

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi lautarotita,

    SUMMARIZE() returns a table, if you want a number, try this measure:

    IngresoTotal 2 = SUMX(SUMMARIZE('ingresos_totales',('ingresos_totales'[cliente_id]),"Cantidad de ingresos", COUNT('ingresos_totales'[fechainicio].[Dia])),[Cantidad de ingresos])

    SUMMARIZE - DAX Guide

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Icon for Administrator rankAdministrator
      2 years ago

      I understand, I used the same calculation to calculate the average accesses.

      But what I want to do is calculate how many days they came in, that is, if customer 1 came in on 12/03 and 13/03 and customer 2 came in on 10/03 and 14/3, the result would have to be 4