Forum Discussion

pedropbribeiro's avatar
pedropbribeiro
New Member
3 years ago
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...
calculation
matrix
measure
total
  • MarkLaf's avatar
    MarkLaf
    3 years ago

    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] )
)

     

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi pedropbribeiro 

strange that the total cost column is in the LocationCoordinates table which is a dimension table! Are you sure about that? If so then how the ResolvedDate (which is in the JIRA fact table) is related to the total cost? The location is primary key (unique) in the LocationsCoordinates table therefore I guess in this case each location has a single total value so what does mean to split it over months? Also it is not clear what is the difference between the first and the second matrices?