Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |