Forum Discussion

hidenseek9's avatar
hidenseek9
Post Patron
1 year ago
Solved

Calculating a total value within a filtered context

I am having a trouble calculating a total value within a filtered context.    I want to calculate a total sales and total volume, within the filtered context.  How can I achieve this?  The total ...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    hidenseek9 , Try using

    dax
    TotalSalesFiltered =
    CALCULATE(
    SUM('ACT Data'[Value]),
    'ACT Data'[Phase] = "Actus",
    'ACT Data'[Line Item] = "Net Sales",
    NOT('ACT Data'[Brand] IN {"New Product", "Discontinued"}),
    ALLEXCEPT(MasterMapping, MasterMapping[Macro Brand])
    )

    TotalVolumeFiltered =
    CALCULATE(
    SUM('ACT Data'[Volume]),
    'ACT Data'[Phase] = "Actus",
    'ACT Data'[Line Item] = "Net Sales",
    NOT('ACT Data'[Brand] IN {"New Product", "Discontinued"}),
    ALLEXCEPT(MasterMapping, MasterMapping[Macro Brand])
    )

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi hidenseek9,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution so that other community members can find it easily.


Thank you.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi hidenseek9,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

 

Thank you.