Trying to get the total of unfiltered value

[Anonymous]

Hi,

I created a measure that will get the total of the unfiltered value.

Table Name: _sp-Total Invoiced to Date - Current Month

[Current P&L] is a measure that's referencing to another table

Formula: ('_sp-Total Invoiced to Date - Current Month'[Total Invoiced Current] - [Current Cost & Expense])

Table Name: _sp-Opportunity Fees and Variations

Div1 = (CALCULATE([Current P&L], REMOVEFILTERS(Projects[Project Name])))

Projects[Project Name] is being used in the slicer.

Any kind of response is much appreciated

Thank you

[amitchandak]

@Anonymous , In such cases, it is better to use an independent project slicer table not joined to your fact.

and use it when need like the example 

Div1 = CALCULATE([Current P&L], filter(Table, Table[Project Name] in values(Projects[Project Name])))