Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Average for matrix columns

I have this matrix table which is showing two different meeting rooms. (EP.02.M01) and (EP.02.M02) Then have a slice which allows me to adjust the date range.  The values in the rows shows, displays how many chairs were used with the hour column.


What I want to get out of this is an acurate average, for example meeting room M02 at 10 am added up to 6 chairs used over the 4 days. So 6/4 = 1.5 (This is the vaule that I want). I can only figure out the total days 6/5 = 1.2, which isnt a true reflection. 

Just on a side note, this data is coming from a direct quary.

 

Thank you in advance

 

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous 

     

    Please read this example:
    First of all, I create a set of sample:

    Then add a measure:

     

    Measure = 
CALCULATE(
		COUNTROWS('Table'),
		'Table'[Column1] <> BLANK()
	)

     

    The result is as follow:

     

    Best Regards,

    Zhengdong Xu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous 

     

    Please read this example:
    First of all, I create a set of sample:

    Then add a measure:

     

    Measure = 
CALCULATE(
		COUNTROWS('Table'),
		'Table'[Column1] <> BLANK()
	)

     

    The result is as follow:

     

    Best Regards,

    Zhengdong Xu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.