I have a fact table and my goal is to do following calculation:
(23833,41 / 36) * 9
What I am having issues getting into the Fact Table is 36. 36 is a sum of the rows in "DagMatriseVerdi2018%".
I've tried to do a group by on %ProposalLine_%UkeID_Key and join back in but I get a really large number as you can see.
LEFT JOIN (Temp_Fakta_2)
Sum(DagMatriseVerdi2018) AS UkeMatriseVerdi2018,
Sum(DagMatriseVerdi2018%) AS UkeMatriseVerdi2018%
Group By %PropsalLine_%UkeID_Key;
Any help is appreciated.
Well - in the table you have a screenshot of this expression should do the sum you're asking for:
Add an extra column and use the above expression just to verify that it calculates to 36 on all the rows.
If it does not return 36 on all rows it might be a "Sum of Expression" that does not calculate to the same of "Sum of Rows". Then the solution is often using the fantastic advanced aggregation function Aggr(...):
Sum( Aggr( Sum([DagMatriseVerdi2018%]) , %ProposalLine_%UkeID_Key ) )
Sorry - answering a bit quickly in the last response not noticing all the dimensions in the chart...
What does this calculate to in a measure in your chart?