CALCULATE with removefilters

The issue you're experiencing is due to the way REMOVEFILTERS works in conjunction with the context of calculations in DAX. When you use REMOVEFILTERS(Table[ErrorType]), it removes the filters from the ErrorType column, but not from other columns or measures that may be affected by those filters.

Let's try to address your problem step by step.

1. CalculateTotal Measure: Since this measure doesn't need the ErrorType filter, it remains as it is.

2. CalculateFailed Measure: This measure needs to have the ErrorType filter removed when calculating. However, using REMOVEFILTERS as you've done may not work as expected because the context might still propagate from other parts of your model.

3. Test Measure: You're trying to calculate the total and failed measures without the ErrorType filter.

A potential solution could involve using the ALLSELECTED function combined with your calculations. Here's how you can modify the Test Measure:

Test Measure =
VAR TotalWithoutErrorTypeFilter =
CALCULATE(
[CalculateTotal],
ALLSELECTED('Table'[ErrorType])
)

VAR FailedWithoutErrorTypeFilter =
CALCULATE(
[CalculateFailed],
ALLSELECTED('Table'[ErrorType])
)

RETURN
TotalWithoutErrorTypeFilter

Here, ALLSELECTED('Table'[ErrorType]) will remove the filter from ErrorType while retaining other filters (like the timestamp). This way, when you calculate your totals and failed counts, it will ignore the ErrorType filter but still respect other filters.

Ensure that you adjust the formula as per your model's specific requirements, but this approach should help you achieve the desired result.

thanks for your kind reply.. i have tried with suggested option , but no luck.do you have any running sample code ?

HI, Anonymous 

try below

CalculateTotal Measure  = 
   COUNTX(
      FILTER(
         all('Table'[errortype],'Table'[Operation],'Table'[ID]),
         'Table'[Operation]="Create"
      ),
      'Table'[ID]
   )

 

CalculateFailed Measure = 
   COUNTX(
       FILTER(
        all('Table'[errortype],'Table'[Operation],'Table'[ID],'Table'[State])
        'Table'[State] = "Failed" && Table[Operation] = "Create"
       ),
     'Table'[Id]
   )

Hi Anonymous 

You seem to want to calculate CalculateFailed/CalculateTotal, and CalculateTotal is not affected by slicers, here is the DAX we offer:

Here is the virtual table we created

The "CalculateTotal" and "CalculateFailed" measures you defined seem to be correct.

CalculateTotal = COUNTX(FILTER('Table', 'Table'[operation]="create"), 'Table'[id])

CalculateFailed = COUNTX(
    FILTER(
        'Table',
        'Table'[state] = "fail" && 'Table'[operation] = "create"),'Table'[id])

The modified Test Measure is as follows, and after the slicer is applied, Total is not affected

Test Measure = 
    VAR TotalWithoutErrorType = CALCULATE([CalculateTotal], ALL('Table'[error type]))
    VAR FailedWithAllFilters = [CalculateFailed]
    RETURN TotalWithoutErrorType

Create a measure to calculate reliability, here are the results

result = [CalculateFailed] / [Test Measure]

If you're still having problems, provide some dummy data and the desired outcome. It is best presented in the form of a table.

Best Regards,

Nono Chen

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