Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
rlongden
New Member

How to calculate sessions per day

I'm trying to calculate the number of sessions in my data. Sessions = a unique combination of Day + Cluster + User.

 

My data resembles this:

DateClusterUser
Nov 1111AAA
Nov 2222AAA
Nov 2333BBB
Nov 2333BBB
Nov 3444CCC
Nov 3333AAA

 

In the above example, I want a calculation that results in this:

  • Nov 1 = 1 session
  • Nov 2 = 2 sessions
    • There are 3 rows however 2 of the rows have the same cluster+user so they only count once
  • Nov 3 = 2 sessions

Ultimately, I want to know how many sessions per day, which I'd show in a table or chart.

 

Any help is appreciated.

1 ACCEPTED SOLUTION
danextian
Super User
Super User

Hi @rlongden ,

 

You may create a calculated column to concatenate those fields if you have other fields in your table:

 

UniqueID =
Table[Date] & Table[Cluster] & Table[User]

 

 

Then create a measure to count the distinct values:

 

Unique Count =
DISTINCTCOUNT ( Table[UniqueID] )

 

 

 

 






Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu.

View solution in original post

3 REPLIES 3
danextian
Super User
Super User

Hi @rlongden ,

 

You may create a calculated column to concatenate those fields if you have other fields in your table:

 

UniqueID =
Table[Date] & Table[Cluster] & Table[User]

 

 

Then create a measure to count the distinct values:

 

Unique Count =
DISTINCTCOUNT ( Table[UniqueID] )

 

 

 

 






Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu.

Thanks to both of you. This gives me what I need. To danextian, you guessed right that my actual data has some other columns that I didn't want in the calculation. I was able to use your example to get it working.

Ashish_Mathur
Super User
Super User

Hi,

Drag Date to the Table visual.  This measure works

Measure = COUNTROWS(DISTINCT(Data))

Untitled.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.