Need help with summing filtered values of a filter.

[kkalyanrr]

Hello,

Please help me with DAX expression to add one more filter label to the filter in given screenshot ( All except C) and the result should be all the sales values summed up except C.

Thanks..

[Smauro · Accepted solution]

First, I think the graph on the right is wrong, it's Sales by Sales.

Second, the easiest way would probably be right-clicking on the Field in Power BI Desktop -> "New Group" and then create one group with "C", and then click on "Include Other group", renaming "Other" to "All except C". Then you can use that for filtering.