Forum Discussion

BIlix's avatar
BIlix
Icon for Helper II rankHelper II
3 years ago
Solved

Calculate 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...
  • johnt75's avatar
    johnt75
    3 years ago

    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
)
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

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
)