Forum Discussion
Solved
Making Matrix Table Aggregates Match
I have a column that shows the last date a contact was interacted with. I'm having that value being aggregated to "Latest" to have it display on the account it belongs to if the group is not expanded...
Hi morgtd30 ,
You could use ISINSCOPE() function to return specific value at subtotal.
measure1 = var max_date = calculate(max([date]),allexcept('table',[city])) var max_column1 = calculate(max([column1]),FILTER(allexcept('table',[city]),[date] = max_date)) return if(isinscope([human]),selectedvalue([column1]),max_column1)The same for column2.
Best Regards,
Jay
Hi morgtd30 ,
You could use ISINSCOPE() function to return specific value at subtotal.
measure1 =
var max_date = calculate(max([date]),allexcept('table',[city]))
var max_column1 = calculate(max([column1]),FILTER(allexcept('table',[city]),[date] = max_date))
return
if(isinscope([human]),selectedvalue([column1]),max_column1)The same for column2.
Best Regards,
Jay
Jay thank you for the help.
I'm not getting any values at summarized at the top for that new measure:
It should bring 948000004 to the top.
Here's an example of how my tables are built:
| Account Name | |||||||||||||||||||||||||
| City 1 | |||||||||||||||||||||||||
| City 2
|
Here's my measure:
ActLastActivityType =
var max_date = calculate(max('Date'[Date]),allexcept(contacts,contacts[Account Name]))
var max_contactrole = calculate(max(contacts[wc_contactrole]),filter(allexcept(contacts,contacts[Account Name]),contacts[wc_lastactivitydate] = max_date))
return
if(isinscope(contacts[fullname]),selectedvalue(contacts[wc_contactrole]),max_contactrole)