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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

BeeleJa ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • 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