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.
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.