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, displ...
  • 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.

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.