Forum Discussion
BIlix
Helper II
Helper IICalculate Values based on a Distribution Key in a linked Table
Hello Community, I want to Calculate Values from my Fact Table based on another Table. I have Story Points in my Fact Table. I already have a Measure to Calculate the StoryPoints i need. TH...
Try
Current Measure = SUMX ( VALUES ( DimDeskDistribution[Desk] ), VAR CurrentProject = SELECTEDVALUE ( DimDeskDistribution[Project ID] ) VAR Result = CALCULATE ( [Storypoint Measure], TREATAS ( { CurrentProject }, DimProject[Project ID] ) ) * CALCULATE ( MAX ( DimDeskdistribution[DeskDistribution] ) ) RETURN Result )
BIlixHelper II
Helper IIThanks again for your help. Unfortunately the error persists.
When the measure is used in a visual it only shows values for Project. All values for desk are blank or not recognized
johnt75
Super User
Super UserHow about
Current Measure =
SUMX (
SUMMARIZE (
DimDeskDistribution,
DimDeskDistribution[Desk],
DimProject[Project ID],
DimDeskdistribution[DeskDistribution]
),
[Storypoint Measure] * DimDeskdistribution[DeskDistribution]
)
- BIlix
In the PRoject View the results are correct.
when selecting desk, there are also results showing. But they are way too high