Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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,
Solved! Go to 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/articles/side-effects-in-dax-of-the-sort-by-column-setting/
Does this help?
Regards
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/articles/side-effects-in-dax-of-the-sort-by-column-setting/
Does this help?
Regards
Yes it worked! Thank you so much!
User | Count |
---|---|
65 | |
60 | |
47 | |
33 | |
32 |
User | Count |
---|---|
85 | |
75 | |
56 | |
50 | |
45 |