Not sure why, but every time I try to use "eazy" BI versus something like excel, it's WAY harder.
Feedback from our company is that this product should be called "hardBI" LOL.
I am trying to just do a simple average of the numbers that show up in eazyBI. Right now I have this:

And all I want to do is calculate the average of all my out of compliance numbers. In excel, I highlight the numbers and click average.
On paper, I just add them all and divide by 9.
In eazyBi, this is like finding the holy grail. Everything wants to use times and ranges and other measures and all this super complicated stuff, and all I need to do is X+Y/2.
I figure if I can get a total, then I can figure out how to average it, but I can only get a total with the "total" button, which I can't use in any calculations. When trying to create a calculated measure to make a total, I can't get anything that works.
I tried this:
Aggregate([Measures].[Out of Compliance])
but it just spits out the same number next to each row, and isn't actually aggregating anything, and all the examples I can find in google are way more complicated than grabbing a simple total. I tried stuff like
Aggregate([Measures].[Out of Compliance].CurrentHierarchy.Members)
however this results in error messages.
Then I run into the problem of getting it to count all of the non-empty rows for the average calculation. When I try
Count([Measures].[Out of Compliance].CurrentHierarchy.Members)
then I always get "1", even though I can plainly see 9 members.
I love the power of eazyBI, but it's so non-intuitive for basic needs, that I'm struggling to understand if I should continue to promote this tool and renew, or let it drop.