DAX measure able to overwrite the filters on filter panel

[tracytran91]

Hi friends, 

I would like to write a DAX measure which is able to overwrite the filter on filter panel. 

In my case, I used filter on this page exclude 2 customers:

On the same page, I wanna have a table to show up the cost of 2 customers. 

Could anyone please kindly help me out regarding this issue?

Thank you for your time. 

[v-chenwuz-msft · Accepted solution]

Hi @tracytran91 

Try this measure:

Customer_M = 
VAR _all =
    SUMMARIZE( ALL( 'Table' ), [Customer], [Cost], "sum", SUM( 'Table'[Cost] ) )
VAR _this =
    SUMMARIZE( 'Table', [Customer], [Cost], "sum", SUM( 'Table'[Cost] ) )
VAR _1 =
    EXCEPT( _all, _this )
RETURN
    CONCATENATEX(_1,[Customer],"
")

Cost_M =
VAR _all =
    SUMMARIZE( ALL( 'Table' ), [Customer], [Cost], "sum", SUM( 'Table'[Cost] ) )
VAR _this =
    SUMMARIZE( 'Table', [Customer], [Cost], "sum", SUM( 'Table'[Cost] ) )
VAR _1 =
    EXCEPT( _all, _this )
RETURN
    CONCATENATEX( _1, FORMAT( [sum], "Standard" ), "
" )

 result wil change if you change the filter on the page:

i put the pbix file in the attachment you can reference.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[VahidDM]

Hi @tracytran91 

You can create a costum table and use that:

New Table = filter(all(Table), [Customer]=121020781&&[Customer]=121020968)

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-calculated-tables

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!