Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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...
Good Luck!
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...
Good Luck!
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |