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



     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Yes, Nathaniel_C 

I just sent this file to play with it with some data.

based on this file data, requirement will be if country is Canada, add $1000 to the total.

 

Note: am using Power BI Report Server Sept 2019 version.

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
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



 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you, Nathaniel_C 

    It seems lieke Totals are not matching. 'Totals' in matrix must also 5000$ more.