Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
Solved! Go to Solution.
@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.
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] )
)
)
)
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..)?
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
8 | |
7 |