Measure not filtering properly

[rkrk7]

I created a measure (below) that is intending to count distince FileIds in a dataset. I want it to be able to be filtered by every other column in the dataset other than Error. This worked last week but, this week it broke somehow and the file count is being filtered by the error column. I have tried all and allexcept but they produce the same results. Thanks!

FileCount = CALCULATE(DISTINCTCOUNT(FeeInaccuracy[FileID]),

REMOVEFILTERS(FeeInaccuracy[Error])

)

[v-tsaipranay]

Hi @rkrk7 ,

We haven’t received an update from you in some time. Could you let us know if the issue has been resolved?
If you still require support, please let us know, we are happy to assist you.

Thank you.

[v-tsaipranay]

Hi @rkrk7 ,

I wanted to follow up on our previous suggestions. We would like to hear back from you to ensure we can assist you further.

Thank you.

[v-tsaipranay]

HI @rkrk7  ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. 

Thank you.

[v-tsaipranay]

Hi @rkrk7 ,

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

Your measure, CALCULATE(DISTINCTCOUNT(FeeInaccuracy[FileID]), REMOVEFILTERS(FeeInaccuracy[Error])), is the correct way to exclude filters on the Error column while keeping filters from other columns.

As mentioned by @danextian and @Ashish_Mathur , this should work unless there have been changes to the visual, page filters, or data model. Make sure the Error column isn’t included in the visual or indirectly filtered by slicers or related tables. Also, avoid using ALLEXCEPT(FeeInaccuracy, FeeInaccuracy[FileID]) as suggested by @Chanty4u , since it removes filters from all columns except FileID, which is not your intended outcome.

If Error is from a related dimension table, consider using REMOVEFILTERS('ErrorTypes') instead. Test your measure in a simple visual and add fields (except Error) one at a time to confirm the expected results.

I hope my suggestions give you good idea, if you need any further assistance, feel free to reach out.

Thank you.

[Ashish_Mathur]

Hi,

By any chance, does this measure work?

FileCount = CALCULATE(DISTINCTCOUNT(FeeInaccuracy[FileID]),ALL(FeeInaccuracy[Error]))

[danextian · Accepted solution]

Hi @rkrk7 

Your formula should work as expected. It removes the filter from the  Error column while keeping filters on other columns intact. So, if you use this column with the measure in a visual, they should display the same values for the whole of error. However, adding another column will naturally break the values down into more detailed segments.

[Chanty4u]

Try this 

FileCount =

CALCULATE(

    DISTINCTCOUNT(FeeInaccuracy[FileID]),

    ALLEXCEPT(FeeInaccuracy, FeeInaccuracy[FileID]

)

)

Or  try this 

FileCount =

CALCULATE(

    DISTINCTCOUNT(FeeInaccuracy[FileID]),

    REMOVEFILTERS('ErrorTypes') -- or REMOVEFILTERS('ErrorTypes'[Error])

)