How to ignore visual column filters?

[Anonymous]

Hi All,

I'm trying to show the same SUM value for both Jan and Feb months, I'm able to show the sum using a Card visual, but once it's in a Matrix it's not showing the sum correctly. 

Example Card Visual:

Example Matrix Visual:

My expected outcome is Jan and Feb showing 519.92 (total sum) for both months in the matrix visual. 

I've tried using this DAX, but it's not working, 

JanFebSUM = CALCULATE([Vol],'g_Calendar'[MMM] = "Jan"||'g_Calendar'[MMM]="Feb",REMOVEFILTERS('g_Calendar[MMM]))

Thanks for the help! 

[OwenAuger · Accepted solution]

Hi @Anonymous 

Based on your matrix visual, the column 'g_Calendar'[MMM] has a Sort By Column defined.

If this is the case, you need to include this column in REMOVEFILTERS as well.

For example, if the Sort By Column is 'g_Calendar[Month], then your measure could be written as follows (I used IN for the filter argument for brevity):

JanFebSUM =
CALCULATE (
    [Vol],
    'g_Calendar'[MMM] IN { "Jan", "Feb" },
    REMOVEFILTERS ( 'g_Calendar'[MMM], 'g_Calendar'[Month] )
)

See these articles:

https://www.sqlbi.com/blog/marco/2018/05/04/removing-column-filter-in-power-bi-when-sort-by-column-is-active/

https://www.sqlbi.com/articles/side-effects-in-dax-of-the-sort-by-column-setting/

Does this help?

Regards

[Anonymous]

Yes it worked! Thank you so much!