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
Anonymous
Not applicable

Dax helped! Average a measure

hello

 

Please can someone advice.

I have a measure # connection which is built from COUNTROWS dax. It count number of rows of this Table1.

It has relationship between TIme dimesion and Date dimension

 

So when i put it in a table format, I got the right output below.

Now I want to be able to AVERAGE # connection. What I want to answer is how many connections at 08:00 in a month. But I dont know hot to put this in dax. Using the figures below the average should return 8.0625 (worked this out in excel). Can someone please help me.

 

Thank you for your advice

pbi1.PNG

1 ACCEPTED SOLUTION
Sean
Community Champion
Community Champion

So # Connections is a Measure built with COUNTROWS - okay!

 

How then is the total only 41? Shouldn't it be the sum of all those numbers which looks to be 129 / 16 days => 8.0625

 

What is the Measure formula?

 

EDIT:

The Denominator part of the Avg # Connections will most like have to be adjusted but this should help you...

 

PQ - % Test.png

 

Good Luck! Smiley Happy

 

View solution in original post

2 REPLIES 2
Sean
Community Champion
Community Champion

So # Connections is a Measure built with COUNTROWS - okay!

 

How then is the total only 41? Shouldn't it be the sum of all those numbers which looks to be 129 / 16 days => 8.0625

 

What is the Measure formula?

 

EDIT:

The Denominator part of the Avg # Connections will most like have to be adjusted but this should help you...

 

PQ - % Test.png

 

Good Luck! Smiley Happy

 

Anonymous
Not applicable

Anyone plz help?

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.