topic Re: Counting how many people used an application? in DAX Commands and Tips

Counting how many people used an application?

sharpedogs — Tue, 04 Feb 2020 21:02:59 GMT

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 case, it's essentially telling me Applications that are rearely used. The data set looks like such.

The DAX sould show that

Office has only 1 user, even through Chad logged in 3 times

Adobe has 3 users

Citris has 1 user

In my practive i thought it would be something like

Measure = calculate( distinctcount [table name], Application name) ----- essentially counitng unique names for each application.. But i am overlooking something?

APPLICATION	USER	DATE
OFFICE	CHAD	JAN 1
ADOBE	CHAD	JAN3
OFFICE	CHAD	FEB 9
OFFICE	CHAD	MAR 8
ADOBE	MAT	MAR 9
ADOBE	MAT	MAR 15
ADOBE	JAMES	MAR 6
CITRIX	JAMES	MAR 6

Re: Counting how many people used an application?

Anonymous — Tue, 04 Feb 2020 23:15:43 GMT

Try this:

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

Re: Counting how many people used an application?

Anonymous — Wed, 05 Feb 2020 01:44:04 GMT

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.

Re: Counting how many people used an application?

sharpedogs — Wed, 05 Feb 2020 16:28:14 GMT

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?

Re: Counting how many people used an application?

sharpedogs — Wed, 05 Feb 2020 16:31:58 GMT

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])

Re: Counting how many people used an application?

Anonymous — Wed, 05 Feb 2020 18:48:54 GMT

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.