The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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. I'm wondering if it's possible to have the other values that display be based on that column:
In this example, Human 3's date has the most recent activity date and displays at the top of the grouping. Is it possible to have it display the corresponding "948000004" and "Site Visit" at the top of the grouping from that row as well?
Solved! Go to Solution.
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
I fixed the issue. I had the wrong date field in the first var. It works perfectly now!
Changed to:
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: