Forum Discussion

UrAvgWally's avatar
UrAvgWally
Icon for Helper I rankHelper I
4 years ago

Help required for Sum , with breakdown by project

Hi All,   I have a table , UnpivotCP with a list of projects , for this example I filtered on one project :   The table has multiple projects, funders and has values for period 1 to 13.   ...
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

UrAvgWally So normally when you see results like that it means that you are missing a relationship in your model.

UrAvgWally's avatar
UrAvgWally
Icon for Helper I rankHelper I
4 years ago

Hi Greg_Deckler , thanks for getting back to me I tried doing this : 

 

Step 1- Make a table with Summarize formula as per below :

 

 

 

Theen as Step 2, Created relationships:

 

Created a relationship with RSKCL for the Funder, and created a relationship of the ProjectNo. With UnPivotCP and UnPivotRF.

 

Step 3:

I used the table i created with the summarize formula,Table ProjectNoKey for the project No as the Column criteria when creating a table visual, and added to that two measures Which is:

 

CPActuals = CALCULATE(SUM(UnpivotCP[Value]),FILTER(UnpivotCP,UnpivotCP[PeriodNo]= MAX(Setup[CP])))
 
CPRF = CALCULATE(SUM(UnpivotRF[Value]),FILTER(UnpivotRF,UnpivotRF[PeriodNo]= MAX(Setup[CP])))
 
And the result is still same as per below : 
 

 

Any idea what I am doing wrong ?