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
Icon for Community Champion rankCommunity 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
      Icon for Community Champion rankCommunity 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.