Forum Discussion

sadiahsapiee's avatar
sadiahsapiee
Icon for Helper I rankHelper I
4 years ago
Solved

Dynamic value calculation based on input

Hi, I have below scenario, I have been tried more than a month to get the solution but still not successful :     in above table the total = 351 and I put in example 35004  User select Sal...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi sadiahsapiee 
    Please try

    Total Cost of Critical =
VAR T1 =
    ADDCOLUMNS (
        VALUES ( 'Table'[Component] ),
        "@Cost", CALCULATE ( SELECTEDVALUE ( 'Table'[Cost] ) ),
        "@Category", [Category]
    )
VAR T2 =
    FILTER ( T1, [@Category] = "Critical" )
RETURN
    SUMX ( T2, [@Cost] )
sadiahsapiee's avatar
sadiahsapiee
Icon for Helper I rankHelper I
4 years ago

 

Total Cost of Critical =
VAR T1 =
    ADDCOLUMNS (
        VALUES ( 'Table'[Component] ),
        "@Cost", CALCULATE ( SELECTEDVALUE ( 'Table'[Cost] ) ),
        "@Category", [Category]
    )
VAR T2 =
    FILTER ( T1, [@Category] = "Critical" )
RETURN
    SUMX ( T2, [@Cost] )

Hi tamerj1 

Is it possible to calculate cost cumulation for Delivery Time lowest to higest? 
I tried this formula but seem not work, it give the the Cost value of the component.
CALCULATE (SUMX(T2, [@Cost]). FILTER(ALL('Table'[Delivery Time]). 'Table'[Delibery Time]>=MIN('Table[Delivery Time])))

I am want result like below:

 CostDelivery TimeCost Cummulation
Comp318550.5
Comp530532.5
Comp12.5122.5

 

Really appreciate your help and thanks in advance.