Removing filters with allselected but does not work

[hidenseek9]

Hi I cannot 

I have a simple table as below. 

I am calculating Net Sales and volume with a simple formula as below by just filtering on Phase and LineItem columns. 

Net Sales - Actual CY = CALCULATE(SUM('RF ACT Data'[Value]),'RF ACT Data'[Phase]="Actual",'RF ACT Data'[Line Item]="Net Sales")

What I would like to do is to calculate Total Sales and Total Volume measures. 

However, when I write a measure as below, this does not work. 

It removes the segment filter, but the brand filter is still working. 

How can I solve this issue?

Net Sales Total- Actual CY =

                CALCULATE(

                    SUM('RF ACT Data'[Value]),

                        'RF ACT Data'[Phase]="Actual",

                        'RF ACT Data'[Line Item]="Net Sales",

                        ALLSELECTED('RF ACT Data'[Brand],'RF ACT Data'[Segment])

                )

[v-pnaroju-msft]

Hi hidenseek9,

We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.

If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.

Thank you.

[v-pnaroju-msft · Accepted solution]

Hi @hidenseek9,

Thank you for reaching out through the Microsoft Fabric Community Forum.

Please find attached the screenshots and the PBIX file, which may help in resolving the issue:

If you find our response helpful, kindly mark it as the accepted solution and consider giving kudos. This will assist other community members who may have similar queries.

Thank you.