none
Measure to calculate portion of total value RRS feed

  • Question

  • Scenario: we have a table with "projects", where every project has a total sum of $$$. We also have a table that defines competencies within project, where every competency might have some percentage value, totaling to 100% within a single project, e.g.:

    ProjectKey | CompetencyKey | CompetencyRatio
    -----
    Project1 | Competency1 | 90
    Project1 | Competency2 | 10
    ProjectX | Competency2 | 100

    I want to define a measure to measure amount of $$$ driven by each competency, based on project's $$$ and competency ratios. The tables are already linked through a project key. Problem is, when I go to "define quick measure" and select "Mathematical - multiply", the system creates a measure that multiplies SUM (CompetencyRatio) by SUM (Project$$$), which is of course incorrect, and it is impossible to define a measure which would simply multiply one by another.

    What is wrong here?

    Thursday, November 7, 2019 3:02 PM

Answers

  • What about adding first a new column to the competency-table with this formula:

    $$$ = (Competency[Percentage]/100)*RELATED(Projects[$$$])

    then add a measure like:

    MeasCompetency = sum(Competency[$$$])


    Query it

    Thursday, November 7, 2019 5:30 PM

All replies