Forum Discussion

sharpedogs's avatar
sharpedogs
Icon for Advocate II rankAdvocate II
6 years ago
Solved

Counting how many people used an application?

Hi,  I have a list of user logins and the applications they log into. I want to write a DAX that calculates the applicaitons that have had less than 5 User logins, 5 to 10 and 10 plus. From a use ca...
  • Anonymous's avatar
    Anonymous
    6 years ago
    Whenever you are declaring variable in dax you have to type keyword "return" and after return whatever is there is the output of your statement.

    Measure=
    Var a=Calculate(distinctcount(table[user]),allexcept(table,table[application])

    Return
    If(a<=5,a,blank())

    Incase the other measure is working incase then just change var a= that summerize one statement.


    Thanks
    Pravin

    If it resolves your problem mark it as a solution and give Kudos.
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Try this:

Measure = 
VAR v_table = SUMMARIZE( Table2, Table2[APPLICATION], Table2[USER])
RETURN
COUNTX( v_table, [APPLICATION])
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    Try this

    Calculate(distinctcount(table[user]),allexcept(table,table[application])

    Thanks,
    Pravin


    If it resolves your problem mark it as a solution and give Kudos.
    • sharpedogs's avatar
      sharpedogs
      Icon for Advocate II rankAdvocate II
      6 years ago

      Hi,

      This essentially ansewered the question i posted, but my mistake for not being clear. I've got this far which is essentially showing the unique users per applicaiton. The second part of the ask (i forgot to post), is now I wnat to have this DAX only show applications that have 5 of fewers users.

       

      i thought i could just add ( <= 5) at the end of DAX and it woudl only show me apps with 5 or fewer unique users. But it's a True/False statement. how do i turn that back into a number? 

       

       

  • sharpedogs's avatar
    sharpedogs
    Icon for Advocate II rankAdvocate II
    6 years ago

    Hi, 

    i'm rather new so some of the syntex throws me off. From DAX bar when i go to put VAR... i get 2 options VAR.P and VAR.S, i'm not sure which you are referring to? As well what does "RETURN" mean? I'm new to DAX so this is a leanring experience for me as well. 

     

    Measure = 
VAR v_table = SUMMARIZE( Table2, Table2[APPLICATION], Table2[USER])
RETURN
COUNTX( v_table, [APPLICATION])

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago
      Whenever you are declaring variable in dax you have to type keyword "return" and after return whatever is there is the output of your statement.

      Measure=
      Var a=Calculate(distinctcount(table[user]),allexcept(table,table[application])

      Return
      If(a<=5,a,blank())

      Incase the other measure is working incase then just change var a= that summerize one statement.


      Thanks
      Pravin

      If it resolves your problem mark it as a solution and give Kudos.