Forum Discussion

Laokoon's avatar
Laokoon
Frequent Visitor
3 years ago

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.

 

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

 

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.

 

 

 

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.

Need Help

2 Replies

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    3 years ago

    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"
)

     

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    3 years ago

    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?