0

Combining measures from different tables

I have 2 datamodels with measures amount which I want to combine to one measure so that I can calculate the sum of these measures. Is this possible? In the first datamodel (see fig1) I have different measures for different statuses (eg status "Bedrag Renteaanbod Uitgebracht" with a total of 307 million). In the second datamodel I have 1 measure "Bedrag" (see fig2), this measure need to be always used in combination with a dimension to "Eventstatus" to the amount for the second datamodel "210. Renteaanbod uitgebracht" is 2.3 million. I want to sum 307 + 2.3 million into 1 grid. Is this possible? Can I create an custom measure to solve this?

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Wailen

    You could create a custom measure from these measures if they were all in the same data model.

    You can create a new model based on these two reports.
    It's really quite simple.

    • You click the "New Data Model"
    • Under "Cloud and Others", you select the "BI Office" data source
    • Then proceed to select your books and relevant reports as your source tables.
    • The rest is described in the following video tutorial "Overview of Data Model".

    Hope this helps.
    Yakov.

    Reply Like
login to reply
Like Follow
  • Status Answered
  • 3 mths agoLast active
  • 1Replies
  • 125Views
  • 1 Following