Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Conditional Sum

Hi, I have Sales Fact table by date. on the report I have Total Sales by 'SaleType' as shown in the picture. and what I need is if SaleType is "Online" , I want to add $0.5 to the Online "Total Sal...
Need Help
Show and Tell
  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    Hi Anonymous ,

    OK used some slicers

    Sales w Segment Channel Parters = 
var _CP = If(MAX(Segement[SegmentName])= "Channel Partners", SUM(SalesFact[ Sales])+5000,SUM(SalesFact[ Sales]))

return _CP

    and added 5000 to Channel Partners. The logic is the same.
    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel



     

Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago
IF(SalesTypeName = "Online", [TotalSaleAmount] * 1.05, [TotalSalesAmount])

Hi Anonymous ,

Try this.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Nathaniel_C : am getting below message to the Measure.

 

A single value for column 'SaleTypeName' in table 'SaleType' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    6 years ago

    Hi Anonymous , are you trying to create a measure?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Yes Nathaniel_C . am trying to create a measure with this requirement and placing this measure on the visual.

       

      I want this adjustment for total sum of "Online". 

      If add a column it will add 0.5 to every row/transaction.

       

      • Nathaniel_C's avatar
        Nathaniel_C
        Community Champion
        6 years ago

        Hi Anonymous ,

        If you want to increase the total by .05 it will be the same either way 10 x10 = 100,
         100*1.05 = 105 or 10 x 10.5=105, yes?

    • Nathaniel_C's avatar
      Nathaniel_C
      Community Champion
      6 years ago

      Anonymous ,

      I would go to Power Query and add a conditional column with the logic from above. 
      Let me know if you have any questions.

      If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
      Nathaniel

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Nathaniel_C .

        Here is the pbix file.

        https://1drv.ms/u/s!Ai0GzdHCLgzPkn-A21nhmXwYmGtz?e=CUol3B

        (ignore notes/comments in this file).

        Thank you for looking into this. Really appreciate.

        again I want this $0.5 adjustment to the total Online Sales.

        another clarification. this 0.5 is not percentage. it is fixed Dollar amount. I just made up this number based on my scenario.