Forum Discussion

BeeleJa's avatar
BeeleJa
Icon for Helper I rankHelper I
5 years ago
Solved

SUMIF to DAX single value to repeat

Hi All,   Can anybody assist with translating this Excel fomula to DAX.   =SUMIFS(S:S;K:K;K108;M:M;"INT_REPAIR";P:P;"Service")   The result I am looking for is a Column where the amount listed ...
Need Help
  • BeeleJa's avatar
    BeeleJa
    5 years ago

    amitchandak - many thanks for the provided solution, it is providing the result I was looking for

    Rgds

BeeleJa's avatar
BeeleJa
Icon for Helper I rankHelper I
5 years ago

Hi amitchandak, Is below sufficient?

 For additional understanding - I want to either have the P_AMOUNT applied when for ProductGroupIS Service is is above zero, else I want the separate P_AMOUNTS to be applied and my intention is to use the result I am now lokking for in a further IF - THEN comparison 

 

CASEIDCASEID_TYPEIDPRODUCTGROUPIDP_AMOUNTSumIf result
W00034470101INT_REPAIRService412.91412.91
W00034470101INT_REPAIREPN 412.91
W00034470101INT_REPAIRParts APU0.15412.91
W00034470101INT_REPAIRParts APU0.15412.91
W00034470102INT_REPAIRParts APU4223.917550
W00034470102INT_REPAIRParts APU151.222550
W00034470102INT_REPAIRService5050
W00034470102INT_REPAIRParts APU26.977550
W00034470102INT_REPAIRParts APU25853.8550
W00034470102INT_REPAIRParts APU 50
W00034470103INT_REPAIRParts APU1694.385352
W00034470103INT_REPAIRParts APU151.2225352
W00034470103INT_REPAIRService352352
W00034470103INT_REPAIRParts APU724.5975352
W00034470103INT_REPAIRParts APU26.9775352
W00034470103INT_REPAIRParts APU45917.025352
W00034470103INT_REPAIRParts APU11.26352
W00034470104INT_REPAIRService9362456.49
W00034470104INT_REPAIRService1520.492456.49
W00034470105INT_REPAIRService651.64651.64
W00034470106INT_REPAIRService 0
W00034470108INT_REPAIRService162.91162.91
W00034470109INT_REPAIRParts APU109.1475155
W00034470109INT_REPAIRService155155
W00034470109INT_REPAIRParts APU3965.8575155
W00034470109INT_REPAIRParts APU0.06155
W00034470109INT_REPAIRParts APU0.32155
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

BeeleJa , create a new column

sumx(filter(Table, [CASEID] =earlier([CASEID]) && [PRODUCTGROUPID] = "Service"),[P_AMOUNT])+0

  • BeeleJa's avatar
    BeeleJa
    Icon for Helper I rankHelper I
    5 years ago

    amitchandak - many thanks for the provided solution, it is providing the result I was looking for

    Rgds