calculate base on a variable of a measure

[Anonymous]

Hello 

I would like to know how could I get a total count of how many values I have displayed in my matrix like below example:

LINES	day 1	day2	day 3	total
top1
top1.1	blank	blank	5.67	1

the values of the matrix are comming from a measure: VAR A = 

AVERAGEX(VALUES(table[Line), CALCULATE(SUM(times[TimeTotal])))

I have the function INSCOPE to display the subtotal per row and per column. 

In column 

VAR Y = SWITCH(

TRUE(),

[User Selection Summary] = "top1.1", A/X,

I need that X to be the COUNT of values per row (in this case 1)

I think I could do a COUNTAX but not sure how because in my table I have per day several hours, I sum up all and in the matrix display per day (based on this measure). 

Hope you can help . thanks

[amitchandak · Accepted solution]

@Anonymous , Create a measure with summarize with all rows and columns

example

measure =

var _tab = summarize(Table, Dim[dim1], Dim2[dim2], "_1", [measure])

return 

countx(_tab, _1)

[Anonymous]

One last thing, 

As you can see below  the total in the corner is 35 so the value I got is 15.10%. 

However, this value I need it to be the sum of the 3 items (in this case) divided by 3items  OR the sum of each value per day divided by number of days. 

do you have any idea to sort out this problem?

thanks!

[Anonymous]

It worked!

Thanks