topic Re: Measure Value from Related tables not showing up in DAX Commands and Tips

Measure Value from Related tables not showing up

yogeshk77 — Mon, 05 Dec 2022 12:08:10 GMT

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?

Re: Measure Value from Related tables not showing up

tamerj1 — Mon, 05 Dec 2022 12:57:19 GMT

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..)?

Re: Measure Value from Related tables not showing up

yogeshk77 — Mon, 05 Dec 2022 13:06:04 GMT

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.

Re: Measure Value from Related tables not showing up

tamerj1 — Mon, 05 Dec 2022 13:19:30 GMT

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] ) ) ) )

Re: Measure Value from Related tables not showing up

yogeshk77 — Mon, 05 Dec 2022 13:50:01 GMT

tamerj1 , I get below error

Re: Measure Value from Related tables not showing up

tamerj1 — Mon, 05 Dec 2022 15:00:05 GMT

yogeshk77

One DIVIDE is missing. Double check my code

Re: Measure Value from Related tables not showing up

yogeshk77 — Tue, 06 Dec 2022 13:41:35 GMT

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

Re: Measure Value from Related tables not showing up

tamerj1 — Thu, 08 Dec 2022 12:04:32 GMT

Hi yogeshk77
Apologies for the late reply

Please see attached file

Re: Measure Value from Related tables not showing up

yogeshk77 — Fri, 09 Dec 2022 04:08:42 GMT

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