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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Laokoon
Frequent Visitor

Filter on one specific column cannot be overwritten

Hi, I'm starting to freak out about the following problem.
I have a model with just 2 tables.

Laokoon_2-1664292293636.png

 

Dim table contains 2 identical columns (initiative Category and Copy initiative Category)

Laokoon_1-1664292172490.png

 

When I create a table visual with each of these columns, and use identical metrics, I get a different result.... 
When I use the initiative Category column, the filter does not override to "Strategic"

if I use any other column from the dim table, everything behaves normally - the filter is always overwritten and I get the same value 6 times.

Laokoon_3-1664292406404.png

Laokoon_5-1664292453101.png

 

 

Laokoon_0-1664291801746.png

 

Any ideas? Is it kind of known bug? I would be grateful for any advice...
I've tried: refresh, delete cache, publish to service - still the same result...

 

Thank you.

2 REPLIES 2
vanessafvg
Super User
Super User

are you able to share some sample data?  

also have you profiled the data in the  table to make sure it is exactly the same?





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




johnt75
Super User
Super User

Do you have a sort by column set for initiative category but not for the copy? If so, you could amend the 2nd measure to

My Measure =
CALCULATE (
    SUM ( 'Fact table'[worklog hours] ),
    REMOVEFILTERS ( 'Dim table' ),
    'Dim table'[initiative category] = "Strategic"
)

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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