Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
FabricDev
Frequent Visitor

DAX Measure Not Filtering Correctly

Hi I have a dax measure with the following calculation:

FabricDev_0-1724563235866.png

When I add this measure a grid with visual I expect every cell to have the same value as the row total, however on some of the cells it applying a filter, which I am not understanding.  Can anyone explain why some cell have 101 instead of 102?

 

FabricDev_2-1724563747416.png

 

FabricDev_1-1724563458292.png

 

2 REPLIES 2
lbendlin
Super User
Super User

Consider using REMOVEFILTERS instead of ALLEXCEPT.

 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

@lbendlin - I have uploaded a sample PBIX.  In the grid, I want to see 102 for every cell.  RemoveFilters did not work for me.  Why is it doing 101 on some cells, but 102 on other?https://drive.google.com/drive/folders/1HbCCuRCloWbCXPavcTcnjIJWWmosldgL?usp=sharing 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.