Forum Discussion
Solved
Creating matrix from two tables and a calculation
Hello, I'm trying to do a matrix with 2 tables, but it doesnt do the calculation properly. This are my 2 tables: Where JIRA.Intervention Area = LocationsCoordinates.Location On th...
There is only one row in 'Locations Coordinates' for an associated TotalCost even as your filter context may have multiple rows from 'JIRA'.
To force PBI to sum 'Locations Coordinates'[TotalCost] for each row of JIRA, you'll need an iterator:
Measure = SUMX( JIRA, RELATED( 'Locations Coordinates'[TotalCost] ) )
MarkLaf
Super User
Super UserThere is only one row in 'Locations Coordinates' for an associated TotalCost even as your filter context may have multiple rows from 'JIRA'.
To force PBI to sum 'Locations Coordinates'[TotalCost] for each row of JIRA, you'll need an iterator:
Measure =
SUMX(
JIRA,
RELATED( 'Locations Coordinates'[TotalCost] )
)
Thank you. This work for me.
