Measure Value from Related tables not showing up

[yogeshk77]

Now, I need to calculated Velocity Per Day for every Area Path & every Iteration by using equation similar to - 

Tasks [Velocity Contributed]  / ( Capacity [Total Capacity] / Capacity [Per Day Capacity]  )

How do I build such a measure?

[tamerj1]

Hi @yogeshk77 
What are the relationships between the tables? At which granularity do you want to perferm the calculation and which type of aggregation is required (SUM, AVERAGE, etc..)?

[yogeshk77]

@tamerj1  Relationships - Both Master Tables (i.e. Area Master & Iteration Master) have Foriegn keys in both the tables (i.e. Task & Capacity)

I need this data for each Area Path AND Iteration Path combination

I will need SUM as an aggregation.

[tamerj1]

Hi @yogeshk77 
Please try

Measure1 =
SUMX (
    CROSSJOIN (
        VALUES ( 'Area Master'[Area Path] ),
        VALUES ( 'Iteration Master'[Iteration Path] )
    ),
    CALCULATE (
        DIVIDE (
            DIVIDE ( SUM ( Tasks[Velocity Contributed] ), SUM ( Capacity[Total Capacity] ) ),
            SUM ( Capacity[Per Day Capacity] )
        )
    )
)

[yogeshk77]

@tamerj1 , I get below error 

[tamerj1]

@yogeshk77 

One DIVIDE is missing. Double check my code 

[yogeshk77]

@tamerj1  Can you please take a look at this PBI file & tell me what's wrong with the calculation of Velocity per Day measure?

Here is the file

[tamerj1 · Accepted solution]

Hi @yogeshk77 
Apologies for the late reply

Please see attached file

[yogeshk77]

@tamerj1 , You are awesome !! Thanks much !!!